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

Problem with pg_dump - reg.

P: n/a
Dear Group,
Thanks for all your support to my previous
postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I
am facing is that when I take a dump of the DB using pg_dump and restore
it using the cat pg_dump_file |psql dbname, I find that some views and
functions are missing. But the same views when created manually in the
newly restored database works fine. I would appreciate your input in
this regard. I am using Redhat 7.3 on one machine and Redhat 8.0 on
another. The same behavior is found on both.
Thanks in advance,

Shan.
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Shanmugasundaram Doraisamy <sh**@ceedees.com> writes:
Thanks for all your support to my previous
postings. I am currently using Postgresql 7.3.4-2PGDG. The problem I
am facing is that when I take a dump of the DB using pg_dump and restore
it using the cat pg_dump_file |psql dbname, I find that some views and
functions are missing.


What errors get reported during the psql run?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.