SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 10:48 AM
| ||||
| ||||
 Re: Postgres version change - pg_dump sarlav kumar wrote, On 2004-12-20 15:40: > I would like to do a pg_dump on the test database, and restore it in > the new database on Postgres 7.4.6. I would like to know if there > would be any problem due to the postgres version/OS change. If so, > could someone tell me what precautions I can take to avoid any > problems? Apart from using the pg_dump from 7.4.6 (see Bruno's answer), you should take care to use the same locale in the new database cluster. I have had problems in the past with unique constraints that could not be restored due to different locale settings. See here: http://www.spinics.net/lists/pgsql/msg05363.html In my case it was not enough to create the database with a different encoding, I had to re-initdb the whole cluster :-/ cheers, stefan ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend      |
|
04-18-2008, 10:48 AM
| ||||
| ||||
| Re: Postgres version change - pg_dump Hi, I think I miscommunicated something. I am doing a pg_dump from Postgres 7.3.2. I am restoring it on Postgres 7.4.6 on Fedora Core 3 on a different server. I tried doing the dump and restoring it on the new DB. I did not have any problem with the UNIQUE contraint so far. But I got an error message saying table "session" does not exist, though it does exist in the old database(from where I did the dump). I also got another error saying "user abc does not exist". On the old DB I have different set of users, with different privileges granted to each of them on the tables. I guess I need to create these set of users in the new DB before doing the dump. Am I right? I am new to postgres administration. So I am not sure what you mean by "same locale in the new database cluster". Could you please explain or point me to a source where I can learn from? Thanks a lot for the help, Saranya --------------------------------- Do you Yahoo!? Jazz up your holiday email with celebrity designs. Learn more. |
Linear Mode
