[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: PSPP Tests: 183

From: John Darrington
Subject: Re: PSPP Tests: 183
Date: Mon, 6 Feb 2012 08:45:45 +0000
User-agent: Mutt/1.5.18 (2008-05-17)

     Jeremy Lavergne <address@hidden> writes:
     > Well I installed postgresql90 and postgresql90-server. That went okay, 
and I was able to configure pspp to pick up the pg_config location correctly. 
Unfortunately, when it goes to run a test the server never comes up for it. 
Mind you, I'm not familiar with postgresql--this is my first time using it :-)
     > Is this possibly a permissions issue?
     > The build environment is run under the "macports" user. 

     > The postgresql90-server package runs under the "postgres" user.

But this test doesn't run the server in the usual manner.  Instead, it creates 
own private server instance running under the permissions of the local user (in 
your case "macports").  So it *shouldn't* clash with any existing server 

     > Or is it simply I'm using a postgresql that's too new?

That is also a possibility.  I don't think I've ever tested it with PostgresqlV9
But it doesn't look like you're getting that far.

     > stdout:
     > The files belonging to this database system will be owned by user 
     > This user must also own the server process.

     > creating template1 database in 
 ... ok

     > Success. You can now start the database server using:
     >     postgres -D 
     > or
     >     pg_ctl -D 
 -l logfile start

Everything seems fine upto here.

     > ./ pg_ctl start -w -o "-k `pwd` -h ''"
     > --- /dev/null   2012-02-04 13:45:32.000000000 -0500
     > +++ 
      2012-02-04 13:46:32.000000000 -0500
     > @@ -0,0 +1,2 @@
     > +pg_ctl: could not start server
     > +Examine the log output.
     > stdout:
     > waiting for server to start....LOG:  could not translate service 
 to address: Non-recoverable failure in name resolution
     > WARNING:  could not create Unix-domain socket
     > FATAL:  no socket created for listening

This is the crux of the problem. It couldn't create a Unix domain socket.  
Quite why 
I'm not sure.  Is that path writable? I'm also unsure why name resolution is 

Maybe Mac doesn't support Unix-domain sockets. or perhaps there is something 
that has to be done to create them?


PGP Public key ID: 1024D/2DE827B3 
fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
See or any PGP keyserver for public key.

Attachment: signature.asc
Description: Digital signature

reply via email to

[Prev in Thread] Current Thread [Next in Thread]