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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com