Re: PSPP Tests: 183

[Ben Pfaff]

John, you wrote the postgresql support and tests.  Do you have
any idea on Jeremy's questions?

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.
>
> Or is this possibly just starting up the server with different flags?
>
> Or is it simply I'm using a postgresql that's too new?
>
>
>
>
> #                             -*- compilation -*-
> 183. get-data-psql.at:123: testing GET DATA /TYPE=PSQL ...
> ./get-data-psql.at:124: initdb -A trust
> stdout:
> The files belonging to this database system will be owned by user "macports".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
> The default database encoding has accordingly been set to SQL_ASCII.
> The default text search configuration will be set to "english".
>
> creating directory 
> /opt/local/var/macports/build/_Users_aeetes_dports_math_pspp-devel/pspp-devel/work/pspp-0.7.9-gb367f5/tests/testsuite.dir/183/cluster
>  ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 20
> selecting default shared_buffers ... 2400kB
> creating configuration files ... ok
> 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
> initializing pg_authid ... ok
> initializing dependencies ... ok
> creating system views ... ok
> loading system objects' descriptions ... ok
> creating conversions ... ok
> creating dictionaries ... ok
> setting privileges on built-in objects ... ok
> creating information schema ... ok
> loading PL/pgSQL server-side language ... ok
> vacuuming database template1 ... ok
> copying template1 to template0 ... ok
> copying template1 to postgres ... 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
>
> ./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
> ............................................................/get-data-psql.at:124:
>  exit code was 1, expected 0
> 183. get-data-psql.at:123: 183. GET DATA /TYPE=PSQL (get-data-psql.at:123): 
> FAILED (get-data-psql.at:124)
>

-- 
Ben Pfaff 
http://benpfaff.org