It is my understanding that EnterpriseDB has many extensions built on
top of PostgreSQL 8.1, and I doubt that an EnterpriseDB backup could
be restored into the open source version of PostgreSQL. It would
probably error out once it tried to create a stored procedure with
the oracle compatibility extensions in it.
Will Reese
http://blog.rezra.com
On May 5, 2006, at 10:20 PM, Guy Rouillier wrote:
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
---------------------------(end of
broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that
your
message can get through to the mailing list cleanly
