Matthew Hixson wrote: > Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1 > database. I imagine Terry's question stems from what would appear to be a straightforward scenario, and hence the need to ask. For the second part of your question, are you asking simply if you can dump a PG database and then import it back into PG? If that is your question, then yes, that's what dump is designed for. > -M@ > > On May 5, 2006, at 4:56 PM, Terry Fielder wrote: > >> By "regular PostgreSQL" do you mean a PostgreSQL 7.x install? >> >> Terry Fielder >> terry@xxxxxxxxxxxxxxxxxx >> Associate Director Software Development and Deployment >> Great Gulf Homes / Ashton Woods Homes >> Fax: (416) 441-9085 >> >> >> >> Matthew Hixson wrote: >>> http://www.enterprisedb.com/news_events/press_releases/04_24_06.do >>> >>> Was wondering if anyone had used that to import an Oracle .dmp >>> file and then export a Postgres 8.1 dump file for import into a >>> regular PostgreSQL database. -M@ >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 6: explain analyze is your friend >>> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 2: Don't 'kill -9' the postmaster >> > > > ---------------------------(end of > broadcast)--------------------------- TIP 5: don't forget to increase > your free space map settings -- Guy Rouillier