Server :: Cannot Create Database In PostgreSQL

Dec 26, 2010

i installed Fedora 14 on my machine,then i installed postgresql in it i started it and configured it after seeing link [URL] i am able to do su - postgres but when i am trying to create database in it am getting error,It is asking for password then i am giving my root password

createdb company
createdb: could not connect to database postgres: FATAL: password authentication failed for user "postgres"

View 1 Replies


Server :: Can't Insert A Record In A Table On Postgresql Database?

Sep 2, 2010

my database (PostgreSQL) has ever funtioned OK, but today don't let me insert a new row in a table and the record itsn't duplicated. I did a vacuum full and reindex the database and the problem continue. I don't know what the fuck is happening

View 2 Replies View Related

Server :: Unable To Connect To Remote PostgreSQL Database With Java.derby

Aug 26, 2010

Trying to get OpenbavoPOS to connect to my remote Postgresql database, but so far i've only been able to connect to the local postgres installation. I _am_ able to access the remote databases with psql. I've read literally dozens of pages, and am pulling my hair out. I'm trying jdbc:derby.// I get back java.sql.SQLException no suitable driver found for jdbc:derby.// If I use jdbc:derby./root/bravo - all is OK, using a local database created in /root I have jdk installed on the client; does it need to be on the server also?

Server = CentOS 5.4 PostgreSQL version 8.1.21
Client = CentOS 4.8 PostgreSQL version 8.1.4


View 1 Replies View Related

Ubuntu :: Add Database To PostgreSQL Daemon

Feb 24, 2011

While watching the text scroll by as I shut down I noticed that there is a PostgreSQL Daemon running somewhere. The question I have is, how do I add myself and my own database to this daemon or do I need to run one on my own user?

View 2 Replies View Related

General :: Sharing Postgresql Database

Oct 1, 2010

Am using mandriva 2008 i developed one simple application using cross platform = Qt3 Database = PostgreSQL

I want to share my database over peer to peer network.

server ip =
client ip =

Now how to share data over those ip?

View 1 Replies View Related

Security :: Securing My Postgresql Database ?

Jan 5, 2010

I run Slackware 13.0 and I have an apache server 2.2.13 with a postgresql 8.4.1 database attached to it via php 5.3.0. Both the apache server and the postgresql database are on the same machine.

I have the apache server port 80 exposed to the WAN. It is not a fqdm, it's just a simple IP address. On my index page, a user can login with a user/password that encrypts to md5 via postgresql and takes them into the database.

Here is the vulnerability. Can't a hacker just scan port 80 and find my ip address running apache. Go to my index page, see that I accept user/password for authentication into my postgresql database. Then they could setup a script to simply inject html GET requests of random users and passwords and use those values on the php page(the one where the action link is pointing to in the form tag) that contains user login/password in php to login to my postgresql database. There's nothing stopping that. It would be a simple dictionary attack.

I checked out postgresql documentation and it suggested using ldap, kerberos, or md5 and not trust. I'm using md5 already. I currently use fail2ban for proftpd and sshd and it works great. After 6 failed user/pass attempts on either of these services, the IP gets banned via iptables for 24 hours. I love it. I was wondering if I could use that. Of course postgresql port is not exposed to the WAN which is a good thing. I know that when I put in a wrong user/pass from my index page, I get sent to a default postgresql pg_connect warning page. Perhaps I can increase the verbosity of postgresql's logger, find the phrase that it spits out when there's been a bad login and create a filter using that.

I understand that the way it is currently setup, my server is pretty secure, but where there's a will there's a way. I just feel that my postgresql database is unprotected even tho the postgresql port is not exposed to the WAN. They could just bruteforce from the apache server.

View 12 Replies View Related

Ubuntu Servers :: How To Clear Postgresql Database Cache

Jan 16, 2010

I just wanna clear database(postgresql) cache so how to do that..and also adempiere cache...

View 1 Replies View Related

General :: Shell Script To Back Up A Postgresql Database?

Jun 4, 2010

I need a shell script to back up and restore a postgresql database.

View 1 Replies View Related

Programming :: Right The Shell Script Which Talk To Postgresql Database?

Jul 22, 2010

i want to right the on linux box which have postgresql and i what some data from the different table and put it in .csv file.

View 2 Replies View Related

Server :: Create New Database From PHP / SQL

Nov 4, 2010

I am now able to create the database using PHP and SQL. But it seems I can only do it as MySQL root user.. $dbuser = 'root'; but is there a way to do that as a regular MySQL user?

View 2 Replies View Related

Server :: Mysql - Cannot Create Database

Jul 28, 2009

I tried creating a database in mysql but couldn't do is the message i got from the shell:


View 4 Replies View Related

CentOS 5 :: Create A Server For A Database That Has A .db File

Jan 25, 2010

I need to create a server for a database that has a .db file that is over 800Gb. now my first disk is 50Gb and i do the standard

100m ext2 boot
2000m swap
* / ext3

now I have a second 1.2T that i want to be /opt is there a way to set up 4kib block size in ext3 in the os install? or should I do it after the install? Is this block size even big enough?

View 11 Replies View Related

Server :: RedHat - Unable To Create Cluster Luci Database Objects

Dec 22, 2010

I want to create redhat cluster on(vmware) OS Redhat Enterprise Server 5.5
Install Luci on node1
Install ricci on node2
Install ricci on node3

All the computer name records in all system host file. When I try to create new cluster( luci_install init) then showing error...
Status messages:
* Host is already authenticated
* Host is already authenticated

The following errors occurred:
* Unable to create the cluster Luci database objects
***No any cluster.conf file created on any node
I have reinstall the node, but getting same error.

View 1 Replies View Related

General :: PostgreSql Error "database Disk Image Is Malformed" After Db Dump

Dec 9, 2010

i created a db_dump from PostgreSql-8.2 and trying to dump it into PostgreSql-8.4 new install. 2 of the 3 databases are fine, except for minor issues, but the 3rd database is giving me the following error message when i start a service calling on it, assist: "database disk image is malformed"

View 1 Replies View Related

Fedora Servers :: Cannot Create DB On PostgreSQL Ascultaţi

Feb 6, 2011

I have tried to create a Postgresql DB from Konsole, but it could not. I received the following messages:

root@fedora-system ~]# chkconfig postgresql on
[root@fedora-system ~]# /etc/init.d/postgresql initdb
Initializing database: [ OK ]


View 4 Replies View Related

Fedora :: Create A Database And Tables?

Jan 13, 2011

I am trying to create a database and tables. Does anyone know a reference website that can help me with this or does anyone know how to do this?

View 3 Replies View Related

Ubuntu Servers :: How To Create New Database

Mar 30, 2010

ubuntu 9.10 64 biti try to install XAMPP and i want to create new database by use phpMyAdmin
at MySQL localhost create new database it show No Privileges how to create new database from terminal

View 4 Replies View Related

Ubuntu Servers :: Create New Database In OpenLDAP?

May 24, 2010

I want to create a new LDAP database.

Part of the new configuration is

dn: olcDatabase={1}hdb,cn=config
objectClass: olcDatabaseConfig
objectClass: olcHdbConfig
olcDatabase: {1}hdb


View 2 Replies View Related

Ubuntu :: Create An OpenBiblio Database User?

Dec 8, 2010

I'm attempting to install OpenBiblio to give it a test drive. I'm having trouble with one of the first steps within the openbiblio install guide. The step is dealing with MySQL in creating user priveleges to the db created. The step is:

Create an OpenBiblio database user. To do this, login to MySQL under the admin userid and run the following SQL command, substituting obiblio_user and obiblio_password with the userid and password of your choice.

mysql> grant all privileges on OpenBiblio.* to obiblio_user@localhost
-> identified by 'obiblio_password';

When I run the "grant all priveleges" command I receive a syntax error. I've spent some time googleing and it comes up with the same command. There has been a few variations attempted such as 'obiblio_user'@'localhost' but still recieve a syntax error.

View 2 Replies View Related

Server :: Postgresql-8.4 Server Doesn't Listen / Fix It?

Nov 23, 2010

I'm getting some problems setting up a Postgresql-8.4 server (using Debian Lenny).
After have installed the PGSQL server, I've changed the following files as bellow code...

If you encounter this message, please check if the server you're trying to contact is actually running PostgreSQL on the given port. Test if you have network connectivity from your client to the server host using ping or equivalent tools. Is your network / VPN / SSH tunnel / firewall configured correctly?
For security reasons, PostgreSQL does not listen on all available IP addresses on the server machine initially. In order to access the server over the network, you need to enable listening on the address first.
For PostgreSQL servers starting with version 8.0, this is controlled using the "listen_addresses" parameter in the postgresql.conf file. Here, you can enter a list of IP addresses the server should listen on, or simply use '*' to listen on all available IP addresses. For earlier servers (Version 7.3 or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'.
You can use the postgresql.conf editor that is built into pgAdmin III to edit the postgresql.conf configuration file. After changing this file, you need to restart the server process to make the setting effective.
If you double-checked your configuration but still get this error message, it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. You probably have some low level network connectivity problems (e.g. firewall configuration). Please check this thoroughly before reporting a bug to the PostgreSQL community.
This is the same configuration that I have in other Lenny server, which works well.

View 2 Replies View Related

Server :: Postgresql Runs In Multiple Pid?

Jul 19, 2010

when i give service postgresql status command. i get the following.ostmaster (pid xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx xxxx) is running...The issue is my postmaster service is running in multiple process ids.As a result my cpu usage becomes high.How to resolve this. my postmaster service need to be run under only one process id

View 3 Replies View Related

Server :: Switch The MySQL To PostgreSQL?

Apr 26, 2011

We've been using a Wiki server at the office for years. It was originally configured to use MySQL and finally after 8+ years we're
moving the Wiki to a new platform of hardware. My question is the Wiki software (MediaWiki) is the only thing still tied to and using MySQL which we want to decommission but we've been using it for years so I'm worried we will lose the data. I've done some Google'ing to find out how can I change the MySQL database dump and successfully export it into my new PostgreSQL database however I don't know how practical or recommended this process is. I found sites like the following:


I don't mean the exact link above but just in general taking a database from MySQL and successfully migrating it for PostgreSQL use?From what I can see in the MySQL database, there appears to be 43 tables with lots of column data and who knows what else:


mysql> show tables;
| Tables_in_wiki |
| dp_archive |
| dp_category |
| dp_categorylinks |


View 2 Replies View Related

Server :: Database Stopped Showing Up - Files Still There - Restore The Database From The Files?

Jul 8, 2011

I recently moved into a new place and when I hooked up my webserver, I wasn't able to bring up my page, even from localhost. With some digging, it seems that I can't access the database that housed my posts (wordpress installation). I looked for the datadir in MySQL and that directory shows the wordpress directory that should be holding the database and all the files are still there. 1) why the database no longer shows up 2) how to restore the database from the files?

View 2 Replies View Related

OpenSUSE :: Create A Database With The Mysql That Came With The Suse Installation?

Aug 11, 2011

i'm trying to create a database with the mysql that came with the suse installation, my problem is that i can't get mysqladmin to work it spits out this: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/run/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/run/mysql/mysql.sock' exists! So I'm stuck at square one php info() seems ok with the installation and the installed client connects to my remote DB ok. I checked the server with ps -ef | grep mysqld and I get the following:

2438 2436 0 15:47 ? 00:00:00 /usr/sbin/mysqld --defaults-file=/home/ben/.local/share/akonadi//mysql.conf --datadir=/home/ben/.local/share/akonadi/db_data/ --socket=/home/ben/.local/share/akonadi/ root 6248 6151 0 16:01 pts/0 00:00:00 grep mysqld

Which doesn't really mean a lot to me but looks ok, anyway my question boils down to does anyone have any obvious ideas of what I'm doing wrong or is, as others have hinted, suse's mysql installation is broken?

View 5 Replies View Related

Ubuntu Multimedia :: Create Ratings Database For MPD Dynamic?

Feb 1, 2010

Does anyone know how the ratings database for mpd-dynamic is meant to look and/or if there's a program to create the database automatically?

View 2 Replies View Related

Ubuntu :: ERROR 1006 (HY000): Can't Create Database

Mar 13, 2011

PHP Code:


Searching around I found a site that says the following:

PHP Code:


/usr/local does not have a mysql folder There is a mysql in /usr/share but no data folder in /usr/share/mysql

what I need to do? I just installed mysql-server on this machine.

I am using: Server version: 5.0.75-0ubuntu10.5 (Ubuntu)

Ubuntu 9.04 Jaunty

View 3 Replies View Related

General :: Makefile - Unable To Create For The Ones That Do Involve Database

Nov 23, 2010

I am new to creating make files. I have been able to create simple makefiles for those applications which do not involve database but am unable to create for the ones that do involve database.

That's how my make file looks




There is no error in the code because when I compile the code through the following command, it gives me no error


The error msg is:


Where am I going wrong? Am I not providing the correct mysql path?

View 4 Replies View Related

Software :: Create Mysql Database From Command Line?

Feb 13, 2010

I want to create database from script directly by taking inputs USER, PASSWORD and DBNAME.code...

How to resolve this or any alternate method (other than entering into mysql prompt like mysql -u USER -pPASSWORD)?

View 3 Replies View Related

Software :: Opsview Unable To Create Database Using Mysql)?

Aug 12, 2010

After the Opsview packages have been installed, it is necessary to configure Opsview and its databases.but while running below command get an error,#mysqladmin -u root password {password}mysqladmin: connect to server at 'localhost' failederror: 'Access denied for user 'root'@'localhost' (using pa

View 4 Replies View Related

Ubuntu :: The PostgreSQL Server Failed To Start

Feb 12, 2010

I'm getting this error message every time I run updates.


dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-8.4; however:
Package postgresql-8.4 is not configured yet.
dpkg: error processing postgresql (--configure):


The following details are provided:

E: postgresql-8.4: subprocess installed post-installation script returned error exit status 1
E: postgresql: dependency problems - leaving unconfigured

View 6 Replies View Related

Copyrights 2005-15, All rights reserved