Hi folks,
I've upgrading from 6.3.2 to 6.4.2 (the -3.i386.rpm version) since there
aren't RPM's yet for -data and -devel pieces of 6.5 ... and am getting
core dumps in 'psql' just after it starts up.
As per the admin documentation, I run 'postmaster -i' as postgres user
in one shell. In another shell I can do a createdb fine, but trying to
open it or template1 gets me a quick core dump:
-----------------
> psql template1
Welcome to the POSTGRESQL interactive sql monitor:
Please read the file COPYRIGHT for copyright terms of POSTGRESQL
type \? for help on slash commands
type \q to quit
type \g or terminate with semicolon to execute query
You are currently connected to the database: template1
Segmentation fault (core dumped)
----------------
Help! I don't see this in the FAQ or anywhere else. I can use a psql
remotely from another machine running 6.3.2 version and that seems to
work, so far. Any immediate suggestions greatly appreciated.
I don't know if it's related, but trying to read back in my pg_dumpall
-o from 6.3.2 is giving me these errors:
-----------------------------
[k6 michael michael] psql -e template1 < pg_dumpall.out
\connect template1
connecting to new database: template1
select datdba into table tmp_pg_shadow from pg_database where
datname = 'template
1';
QUERY: select datdba into table tmp_pg_shadow from pg_database
where datname = 't
emplate1';
ERROR: tmp_pg_shadow relation already exists
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
QUERY: delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
DELETE 1
drop table tmp_pg_shadow;
QUERY: drop table tmp_pg_shadow;
ERROR: pg_ownercheck: user "michael" not found
copy pg_shadow from stdin;
QUERY: copy pg_shadow from stdin;
ERROR: pg_aclcheck: user "michael" not found
michael 500 t t t t \N \N
\? -- help
\a -- toggle field-alignment (currently on)
\C [<captn>] -- set html3 caption (currently '')
\connect <dbname|-> <user> -- connect to new database (currently
'template1')
[snip]
\! [<cmd>] -- shell escape or command
\connect template1 michael
connecting to new database: template1 as user: michael
FATAL 1: SetUserId: user 'michael' is not in 'pg_shadow'
Could not connect to new database. exiting
-------------------------
TIA,
--Michael
