When updating an existing postgresql installation from Release 1.3 to
Release 2.0, the instructions in the spec file don't completely cover the
dump/restore process. The new version of postgresql no longer has a
template0 so the restore from the previous fails.
The workaround that I used was to create a template0 database before doing
the restore seems to have worked:
cd $l_prefix/var/postgresql # lazy way to shorter path
pg_createdb -U postgresql template0
bzcat db.dump.sql.bz2 | psql -U postgresql
pg_dropdb -U postgresql template0
Bill
--
INTERNET: [EMAIL PROTECTED] Bill Campbell; Celestial Software LLC
UUCP: camco!bill PO Box 820; 6641 E. Mercer Way
FAX: (206) 232-9186 Mercer Island, WA 98040-0820; (206) 236-1676
URL: http://www.celestial.com/
``The trouble with fighting for human freedom is that one spends most of
one's time defending scoundrels. For it is against scoundrels that
oppressive laws are first aimed, and oppression must be stopped at the
beginning if it is to be stopped at all.'' -- H. L. Mencken
______________________________________________________________________
The OpenPKG Project www.openpkg.org
Developer Communication List [EMAIL PROTECTED]
