I'm getting the following error when building with current sources
as of 12-Mar-2000:
ERROR: Relation 'pg_user' does not exist
This happens whilst creating a new DB from scratch (initdb-createdb-psql).
Hints greatly appreciated...
Regards,
Ed Loehr
Detailed output for context:
% killall postmaster
%
[1]+ Done postmaster -B 1024 -N 20 -o "-F -S 4096" 1>&server_log
% echo $PGDATA
/usr/local/pgsql/data
% rm -rf /usr/local/pgsql/data
% initdb;
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server process.
Creating database system directory /usr/local/pgsql/data
Creating database system directory /usr/local/pgsql/data/base
Creating database XLOG directory /usr/local/pgsql/data/pg_xlog
Creating template database in /usr/local/pgsql/data/base/template1
Creating global relations in /usr/local/pgsql/data/base
Adding template1 database to pg_database
Creating view pg_user.
Creating view pg_rules.
Creating view pg_views.
Creating view pg_tables.
Creating view pg_indexes.
Loading pg_description.
Vacuuming database.
Success. You can now start the database server using
/bin/postmaster -D /usr/local/pgsql/data or
/bin/pg_ctl -D /usr/local/pgsql/data start
% echo query > /usr/local/pgsql/data/pg_options
% postmaster -B 1024 -N 20 -o "-F -S 4096" >& server_log &
[1] 4184
% createdb emsdb
CREATE DATABASE
# Load a dump file created with 6.5.2 pg_dump...
% gunzip -c ~/backups/2000/03-Mar/12-Sun/emsdb.1.4.1.3.20000312.161532.blue.gz | psql
-d emsdb > log
ERROR: Relation 'pg_user' does not exist
ERROR: Relation 'pg_user' does not exist
...
% gunzip -c ~/backups/2000/03-Mar/12-Sun/emsdb.1.4.1.3.20000312.161532.blue.gz | less
\connect - postgres
CREATE SEQUENCE "ems_configuration_id_seq" start 2 increment 1 maxvalue 2147483647
minvalue 1 cache 1 ;
SELECT nextval ('ems_configuration_id_seq');
...
% less server_log
20000313.11:31:36.427 [4185] DEBUG: Data Base System is starting up at Mon Mar 13
11:31:36 2000
20000313.11:31:36.427 [4185] DEBUG: Data Base System was shut down at Mon Mar 13
11:31:05 2000
20000313.11:31:36.427 [4185] DEBUG: CheckPoint record at (0, 200)
20000313.11:31:36.427 [4185] DEBUG: Redo record at (0, 200); Undo record at (0, 0)
20000313.11:31:36.427 [4185] DEBUG: NextTransactionId: 8734; NextOid: 0
20000313.11:31:36.427 [4185] DEBUG: Invalid NextTransactionId/NextOid
20000313.11:31:36.429 [4185] DEBUG: Data Base System is in production state at Mon
Mar 13 11:31:36 2000
20000313.11:32:00.417 [4199] query: CREATE DATABASE "emsdb"
20000313.11:32:00.418 [4199] ProcessUtility: CREATE DATABASE "emsdb"
20000313.11:32:30.240 [4214] query: SELECT usesuper FROM pg_user WHERE usename =
'postgres'
20000313.11:32:30.240 [4214] ERROR: Relation 'pg_user' does not exist
20000313.11:32:30.253 [4215] query: SELECT usesuper FROM pg_user WHERE usename =
'postgres'
20000313.11:32:30.254 [4215] ERROR: Relation 'pg_user' does not exist
20000313.11:32:30.255 [4215] query: CREATE SEQUENCE "ems_configuration_id_seq" start
2 increment 1 maxvalue 2147483647 minvalue 1 cache 1
20000313.11:32:30.255 [4215] ProcessUtility: CREATE SEQUENCE
"ems_configuration_id_seq" start 2 increment 1 maxvalue 2147483647 minvalue 1 cache 1
20000313.11:32:30.266 [4215] query: SELECT nextval ('ems_configuration_id_seq')
...
