[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: postgresql test failures
Re: postgresql test failures
Sat, 19 Jan 2019 18:28:08 +0000
Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.2.1
Haven't looked at the bootstrapping from pspp, but have some experience
with postgres connections.
Postgresql generally requires a database to exist on the cluster on the
server for the client to connect to. There may be a system-provided
"postgres" database you can use, then create your "blp" database, and
then you can reconnect to "blp" instead.
This makes me think the bootstrap is trying to connect to the database
it wants to create: can you have it try "postgres" as the connection
database and then create "blp"?
On 1/19/19 12:16 PM, 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
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.
/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
../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH pg_ctl start -w -o "-k
$socket_dir -h ''"
waiting for server to start....2019-01-19 09:12:25.681 PST  LOG: listening on
Unix socket "/tmp/tmp.xPYKH8shgE/.s.PGSQL.6543"
2019-01-19 09:12:25.719 PST  LOG: database system was shut down at
2019-01-19 09:12:25 PST
2019-01-19 09:12:25.729 PST  LOG: database system is ready to accept
../../tests/get-data-psql.at:149: PATH=$PG_PATH:$PATH createdb -h "$socket_dir"
-p $PG_PORT $PG_DBASE
../../tests/get-data-psql.at:149: psql -h "$socket_dir" -p $PG_PORT $PG_DBASE <
--- /dev/null 2019-01-14 21:20:12.627999704 -0800
2019-01-19 09:12:26.099989467 -0800
@@ -0,0 +1 @@
+psql: FATAL: database "blp" does not exist
2019-01-19 09:12:26.102 PST  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):
pspp-dev mailing list