Problems With pg_dumpall and OIDs
От | Tim Gustafson |
---|---|
Тема | Problems With pg_dumpall and OIDs |
Дата | |
Msg-id | 623884546.38971227134154902.JavaMail.root@mail-01.cse.ucsc.edu обсуждение исходный текст |
Ответы |
Re: Problems With pg_dumpall and OIDs
Re: Problems With pg_dumpall and OIDs |
Список | pgsql-admin |
Hello, I currently have a old GForge installation running on Postgres 7.4.19. GForge relies on the OID columns of their applicationtables for different things. I'm trying to upgrade Postgres to 8.2, and in order to do so, I'm doing: pg_dumpall --oids --clean > foo.sql However, the "CREATE TABLE" statements in foo.sql don't have "WITH OIDS" specified, so when the tables are created in thenew server, they are not getting OID columns, and then the data load portion of the SQL script appears to essentiallybe ignoring the OID information. Is there an updated pg_dumpall that fixes this problem? Was this a known issue in the 7.4.19 pg_dumpall that was fixed? Any suggestions on how best to get the data out of the 7.4 server and in to the 8.2 server while maintaining all theOID information? Thanks for all your help! Tim Gustafson SOE Webmaster UC Santa Cruz tjg@soe.ucsc.edu 831-459-5354
В списке pgsql-admin по дате отправления: