Novice question

[CY]

Dear list

Is is possible to copy /var/lib/pgsql from one computer to another and
able login like the 1st computer?
I have a production computer and a test computer.

According to some literature, this can be done. However, I found that
the database and user missing when
use wiht psql.

Currently, I am uisng RH Linux 8.0 wiht Postgres 7.2.2.

Thank you.


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Chris Travers]

Try doing an initdb on the other computer OR shutting down postgreSQL
(mandatory) and then copying over your data directory.

Best Wishes,
Chris Travers
----- Original Message -----
From: "CY" <***@pc.jaring.my>
To: "pgsql-admin" <pgsql-***@postgresql.org>
Sent: Thursday, January 08, 2004 2:28 PM
Subject: [ADMIN] Novice question

Post by CY
Dear list
Is is possible to copy /var/lib/pgsql from one computer to another and
able login like the 1st computer?
I have a production computer and a test computer.
According to some literature, this can be done. However, I found that
the database and user missing when
use wiht psql.
Currently, I am uisng RH Linux 8.0 wiht Postgres 7.2.2.
Thank you.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match