Re: Transfer db from one port to another

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