By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,558 Members | 1,533 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,558 IT Pros & Developers. It's quick & easy.

Restoring the dump in a new database does not contain oids

P: 13
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
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
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

Post your reply

Sign in to post your reply or Sign up for a free account.