Re: PSPP Tests: 183

[John Darrington]

     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 
its
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 
process.

     > 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 
"macports".
     > This user must also own the server process.

     > creating template1 database in 
/opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/183/cluster/base/1
 ... ok


     > Success. You can now start the database server using:
     >
     >     postgres -D 
/opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/183/cluster
     > or
     >     pg_ctl -D 
/opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/183/cluster
 -l logfile start

Everything seems fine upto here.


     > ./get-data-psql.at:124: pg_ctl start -w -o "-k `pwd` -h ''"
     > --- /dev/null   2012-02-04 13:45:32.000000000 -0500
     > +++ 
/opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/at-groups/183/stderr
      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 
"/opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/183/.s.PGSQL.6543"
 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 
involved.

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


J'

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

signature.asc
Description: Digital signature