Re: Transfer db from one port to another - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Transfer db from one port to another
Date
Msg-id 5683E729.5060608@aklaver.com
Whole thread Raw
In response to Re: Transfer db from one port to another  (Killian Driscoll <killiandriscoll@gmail.com>)
List pgsql-general
On 12/29/2015 11:38 PM, Killian Driscoll wrote:
> On 24 December 2015 at 18:33, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> wrote:
>

>
>
> It worked - thank you very much for your time.
>
> Regarding the file format used: I had used the pg_dump with .sql, but
> you suggested .out. Is there a particular reason to use .out instead of
> .sql when backing up?

I do that to distinguish between plain text dumps(*.sql) and custom
format dumps(*.out) for myself. Postgres itself does not care about the
extension, or if there is an extension at all.

>
>
>
>     --
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Transfer db from one port to another
Next
From: Andy Colson
Date:
Subject: Re: cannot get stable function to use index