PostgreSQL createdb fails

QNX Newsgroups (Archives) comp.os.qnx
1

I am trying to use PostgreSQL 7.2.1 on QNX 6.2.0.

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

http://www.postgresql.org/docs/7.2/interactive/installation.html#INSTALL

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

2

spr@shaw.ca sed in <slrnc34iij.i8h.spr@samantha.armispiansystems.ca>:

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

I thought QNX didn’t support UNIX domain sockets.
Revert to TCP sockets if you can.

kabe

3

On Fri, 20 Feb 2004 01:43:36 JST, <kabe@sra-tohoku.co.jp> wrote:

spr@shaw.ca > sed in <> slrnc34iij.i8h.spr@samantha.armispiansystems.ca> >:

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

I thought QNX didn’t support UNIX domain sockets.
Revert to TCP sockets if you can.

The current version of QNX6 (6.2.1B) does support Unix domain sockets.

From the error message this looks like a config problem in that the Unix
domain socket hasn’t been given a name. Sorry we use MySQL not Postgres so
I can’t offer any more help. (BTW MySQL works fine using unix domain
sockets).

Rob Rutherford

4

Robert Rutherford wrote:

On Fri, 20 Feb 2004 01:43:36 JST, <> kabe@sra-tohoku.co.jp> > wrote:

spr@shaw.ca > sed in <> slrnc34iij.i8h.spr@samantha.armispiansystems.ca> >:

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

I thought QNX didn’t support UNIX domain sockets.
Revert to TCP sockets if you can.

The current version of QNX6 (6.2.1B) does support Unix domain sockets.

From the error message this looks like a config problem in that the Unix
domain socket hasn’t been given a name. Sorry we use MySQL not Postgres so
I can’t offer any more help. (BTW MySQL works fine using unix domain
sockets).

In the end we went with MySQL too. I am already familiar with it and it
wasn’t hard to build.

…Stephen

5

On 24 Feb 2004 19:16:12 GMT, Stephen Rasku wrote:

Robert Rutherford wrote:
In the end we went with MySQL too. I am already familiar with it and it
wasn’t hard to build.

Build??? You can download the latest binaries for QNX 6.21 direct from
MySQL (http://www.mysql.com/downloads/mysql-4.0.html). These are updated
for every release :slight_smile:

Rob Rutherford

6

http://www.qnxzone.com/downloads/PostgreSQL/

Take a look at the readme and pgstl.start script.

– igor

“Stephen Rasku” <spr@shaw.ca> wrote in message
news:slrnc3naan.lip.spr@samantha.armispiansystems.ca…

Robert Rutherford wrote:

On Fri, 20 Feb 2004 01:43:36 JST, <> kabe@sra-tohoku.co.jp> > wrote:

spr@shaw.ca > sed in <> slrnc34iij.i8h.spr@samantha.armispiansystems.ca> >:

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

I thought QNX didn’t support UNIX domain sockets.
Revert to TCP sockets if you can.

The current version of QNX6 (6.2.1B) does support Unix domain sockets.

From the error message this looks like a config problem in that the Unix
domain socket hasn’t been given a name. Sorry we use MySQL not Postgres
so
I can’t offer any more help. (BTW MySQL works fine using unix domain
sockets).

In the end we went with MySQL too. I am already familiar with it and it
wasn’t hard to build.

…Stephen