On Friday 02 August 2002 12:46 pm, Areski Belaid wrote: > Hello to everyone, > > I have a application using Postgres DB and I going to create a new version > on the same server... I would like duplicate my database with all structure > and data > like that, I can update this new version and keep the last one active > during the release version. > > BUT, doesm't work =( > > First I create the backup, like that : > pg_dump > db.out > > > After I try to duplicate this one : > > So I create a other user "new-user" and I create a new db "new-db" > (new-user is the owner new-db) > next step : > change 1 ligne on db.out file : > Replace : "\connect - dbname" by "\connect - new-db" > > To finish, I try that : > psql new-db< db.out try psql -f db.out newdb run the whole thing as user postgres, that should work. > > > > Of course, it doesn't work, otherwise I won't disturb you =) > > Error message: > 1: You are now connected as new user new-db > 2: ERROR: Relation 'table1' already exists > 3: ERROR: Relation 'table1' already exists > 4: ... > > > > I tried a lot of think without success, Some helpsssssssss pleaseee. > > > > Thanks to the community, Areski > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html
