Novice question
Novice question
От:
CY <cyhoong@pc.jaring.my>
Дата:
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.
Re: Novice question
От:
"Chris Travers" <chris@travelamericas.com>
Дата:
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" To: "pgsql-admin" Sent: Thursday, January 08, 2004 2:28 PM Subject: [ADMIN] Novice question > 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 > >