Restoring the dump in a new database does not contain oids

ntech

Hello,
i am facing a problem. I am using postgresql database in Linux. After taking the dump of any postgresql database, when i restore the dump file into a new database, i dont get any oids. so can anyone help me in this issue? Does it happen due to version mismatch? how do i take the dump so that when i restore it, the oids are also available?

Thanks,
Ntech

Nov 25 '07 #1

rski

Hello,
i am facing a problem. I am using postgresql database in Linux. After taking the dump of any postgresql database, when i restore the dump file into a new database, i dont get any oids. so can anyone help me in this issue? Does it happen due to version mismatch? how do i take the dump so that when i restore it, the oids are also available?

Thanks,
Ntech

Is option 'default_with_oids' (or something like that) turned on in postgresql.conf?

Nov 25 '07 #2