[plug] Twig

[Andrew Barbara]

What if you cant bringthe old system up??
any ways to doit just with the data?

>>> tony at cantech.net.au 06/28/01 02:54pm >>>
On Thu, 28 Jun 2001, Andrew  Barbara wrote:

> Hi All
> I was just wondering if anyone knows how to import a database from one server to another (from one postgresql 6.5 to 7.0)
> its a twig database.
> Thanks

BEFORE you remove pgsql 6.x from your system:
remove any auth requirements you have for unix sockets.

pg_dumpall >/tmp/pg_db_backup.

remove/upgrade/install 7.X
do the appropriate to create your pgsql and root users.
then psql </tmp/pg_db_backup

.... LOTS ofd sql output.

That should resoter all your databases and system tables.

ON a personal note postgress 7.1 rocks!

Yours Tony.

/*
 * "The significant problems we face cannot be solved at the
 * same level of thinking we were at when we created them."
 * --Albert Einstein
 */