EnterpriseDB
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@
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085
Matthew Hixson wrote:
Show quoted text
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
Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1
database.
-M@
On May 5, 2006, at 4:56 PM, Terry Fielder wrote:
Show quoted text
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085Matthew 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
Terry Fielder wrote:
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install?
No he probably means the current Open Source release from the PostgreSQL
Development group thus 8.1.3.
Joshua D. Drake
Terry Fielder
terry@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085Matthew 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
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
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@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085Matthew 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
Import Notes
Resolved by subject fallback
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:
Show quoted text
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@greatgulfhomes.com
Associate Director Software Development and Deployment
Great Gulf Homes / Ashton Woods Homes
Fax: (416) 441-9085Matthew 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@postgresql.org so that
your
message can get through to the mailing list cleanly