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_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