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-9085
>>
>>
>>
>> Matthew Hixson wrote:
>>> http://www.enterprisedb.com/news_eve...es/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