Re: postgresql test failures

[Ben Pfaff]

Thanks for the fix, it also fixed the problem here (also on Debian).

On Sun, Jan 20, 2019 at 11:51:20AM +0100, John Darrington wrote:
> I pushed a fix which seems to solve the problem at least on debian ...
> 
> J'
> 
> On Sun, Jan 20, 2019 at 09:00:59AM +0100, John Darrington wrote:
>      I had a look at this, and spoke to some of the postgres people.  
>      
>      It seems that postgres is not after all the guilty party. Debian is.
>      
>      Debian's /usr/bin/psql is a wrapper around the real psql which breaks
>      things.
>      
>      I'll see what the best way around this problem is.
>      
>      J'
>      
>      On Sat, Jan 19, 2019 at 08:53:15PM +0100, John Darrington wrote:
>           I'm getting the same results.  
>           
>           So I suspect the test needs to be adjusted to suit recent psqlserver
>           versions.
>           
>           J'
>           On Sat, Jan 19, 2019 at 09:16:09AM -0800, Ben Pfaff wrote:
>                I've recently had to move development to a new laptop because 
> my
>                previous one died suddenly.  I'm getting the following test 
> failure
>                reliably on the new one.  I don't know much about postgresql 
> setup, so
>                I'd appreciate any advice.
>                
>                #                             -*- compilation -*-
>                250. get-data-psql.at:147: testing GET DATA /TYPE=PSQL ...
>                ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH initdb 
> -A trust
>                stdout:
>                The files belonging to this database system will be owned by 
> user "blp".
>                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".
>                
>                Data page checksums are disabled.
>                
>                creating directory 
> /home/blp/pspp/master/_build/tests/testsuite.dir/0250/cluster ... ok
>                creating subdirectories ... ok
>                selecting default max_connections ... 100
>                selecting default shared_buffers ... 128MB
>                selecting dynamic shared memory implementation ... posix
>                creating configuration files ... ok
>                running bootstrap script ... ok
>                performing post-bootstrap initialization ... ok
>                syncing data to disk ... ok
>                
>                Success. You can now start the database server using:
>                
>                    pg_ctl -D 
> /home/blp/pspp/master/_build/tests/testsuite.dir/0250/cluster -l logfile start
>                
>                ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH pg_ctl 
> start -w -o "-k $socket_dir -h ''"
>                stdout:
>                waiting for server to start....2019-01-19 09:12:25.681 PST 
> [21495] LOG:  listening on Unix socket "/tmp/tmp.xPYKH8shgE/.s.PGSQL.6543"
>                2019-01-19 09:12:25.719 PST [21557] LOG:  database system was 
> shut down at 2019-01-19 09:12:25 PST
>                2019-01-19 09:12:25.729 PST [21495] LOG:  database system is 
> ready to accept connections
>                 done
>                server started
>                ../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH createdb 
> -h "$socket_dir" -p $PG_PORT $PG_DBASE
>                stderr:
>                stdout:
>                ../../tests/get-data-psql.at:149: psql -h "$socket_dir" -p 
> $PG_PORT $PG_DBASE < populate.sql
>                --- /dev/null   2019-01-14 21:20:12.627999704 -0800
>                +++ 
> /home/blp/pspp/master/_build/tests/testsuite.dir/at-groups/250/stderr       
> 2019-01-19 09:12:26.099989467 -0800
>                @@ -0,0 +1 @@
>                +psql: FATAL:  database "blp" does not exist
>                stdout:
>                2019-01-19 09:12:26.102 PST [21859] FATAL:  database "blp" 
> does not exist
>                ../../tests/get-data-psql.at:149: exit code was 2, expected 0
>                server shutting down
>                250. get-data-psql.at:147: 250. GET DATA /TYPE=PSQL 
> (get-data-psql.at:147): FAILED (get-data-psql.at:149)
>                
>                _______________________________________________
>                pspp-dev mailing list
>                address@hidden
>                https://lists.gnu.org/mailman/listinfo/pspp-dev
>           
>           -- 
>           Avoid eavesdropping.  Send strong encrypted email.
>           PGP Public key ID: 1024D/2DE827B3 
>           fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
>           See http://sks-keyservers.net or any PGP keyserver for public key.
>           
>      
>      -- 
>      Avoid eavesdropping.  Send strong encrypted email.
>      PGP Public key ID: 1024D/2DE827B3 
>      fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
>      See http://sks-keyservers.net or any PGP keyserver for public key.
>      
> 
> -- 
> Avoid eavesdropping.  Send strong encrypted email.
> PGP Public key ID: 1024D/2DE827B3 
> fingerprint = 8797 A26D 0854 2EAB 0285  A290 8A67 719C 2DE8 27B3
> See http://sks-keyservers.net or any PGP keyserver for public key.
>