dbTalk Databases Forums  

Createdb fails

comp.databases.postgresql.novice comp.databases.postgresql.novice


Discuss Createdb fails in the comp.databases.postgresql.novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Stephen Rasku
 
Posts: n/a

Default Createdb fails - 02-13-2004 , 10:48 AM






I am trying to use PostgreSQL 7.2.1 on QNX 6.2.0. This version is
available as a third party package from QNX.

After installing the package, I am trying to initialize the database as
described in the Administrator Manual.


http://www.postgresql.org/docs/7.2/i...n.html#INSTALL
-SHORT

I started postmaster using the following command:

postmaster -D /var/postgres/data >>logfile 2>&1 &

I have verified that postmaster is running by using "ps".

I then try to create a database using the following command:

createdb test

and I get the following error:

psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket ""?
createdb: database creation failed

The odd thing that I notice is that the socket is null (i.e. ""). Is
this expected? Anyone know what I am doing wrong?

....Stephen


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: Createdb fails - 02-16-2004 , 09:29 AM






Take a look at the pg_hba.conf file. You probably need to make some
adjustments to permissions here. Read the file in it's entirety. It's
well documented, and though boring, it does provide good information.

-Ken


--

KG Hagans Professional Services Group
Westerville, Ohio
ken (AT) kghagans (DOT) com
www.kghagans.com


""Stephen Rasku"" <srasku (AT) tantalus-systems (DOT) com> wrote

Quote:
I am trying to use PostgreSQL 7.2.1 on QNX 6.2.0. This version is
available as a third party package from QNX.

After installing the package, I am trying to initialize the database as
described in the Administrator Manual.


http://www.postgresql.org/docs/7.2/i...n.html#INSTALL
-SHORT

I started postmaster using the following command:

postmaster -D /var/postgres/data >>logfile 2>&1 &

I have verified that postmaster is running by using "ps".

I then try to create a database using the following command:

createdb test

and I get the following error:

psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket ""?
createdb: database creation failed

The odd thing that I notice is that the socket is null (i.e. ""). Is
this expected? Anyone know what I am doing wrong?

...Stephen


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.