Re: Transfer db from one port to another

On 23 December 2015 at 20:19, Melvin Davidson <melvin6925(at)gmail(dot)com> wrote:

> It's possible the restore is still building indexes.
>
> What does it show when you run this query?
>
Where do I run this query? Do I stop the restore that is 'active'?

>
> SELECT datname,
> pid as pid,
> client_addr,
> usename as user,
> query,
> CASE WHEN waiting = TRUE
> THEN 'BLOCKED'
> ELSE 'no'
> END as waiting,
> query_start,
> current_timestamp - query_start as duration
> FROM pg_stat_activity
> WHERE pg_backend_pid() <> pid
> ORDER BY datname,
> query_start;
>
>
> On Wed, Dec 23, 2015 at 2:14 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
> wrote:
>
>> On 12/23/2015 11:09 AM, Killian Driscoll wrote:
>>
>>> On 23 December 2015 at 20:07, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>> wrote:
>>>
>>> On 12/23/2015 11:03 AM, Killian Driscoll wrote:
>>>
>>> On 23 December 2015 at 16:02, Adrian Klaver
>>> <adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>> wrote:
>>>
>>> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>>>
>>> On 23 December 2015 at 15:47, Adrian Klaver
>>> <adrian(dot)klaver(at)aklaver(dot)com
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>>
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>>
>>>
>>>
>>>
>>> So cd into:
>>>
>>> C:\Program Files\PostgreSQL\9.3\bin
>>>
>>> and try:
>>>
>>> pg_dump --help
>>>
>>> that will at least establish that the
>>> command is
>>> being found.
>>>
>>>
>>> OK - --help on the 9.3 lists help options
>>>
>>>
>>> In your original post you said you have a 9.3
>>> instance and
>>> a 9.4
>>> instance.
>>>
>>> >From your post I would say the 9.3 instance was
>>> installed
>>> by the
>>> one click installer from EDB and the 9.4 from
>>> Bitami, is
>>> that correct?
>>>
>>> Correct.
>>>
>>>
>>> So do you know where the 9.4 binaries are
>>> installed?
>>>
>>> If by binaries, you mean the program files they are
>>> installed
>>> C:\Bitnami\wappstack-5.5.30-0\postgresql\bin
>>>
>>>
>>> Per previous posts you want, whenever possible, to us a
>>> newer
>>> version of pg_dump to move a database from an older
>>> version(9.3) to
>>> a newer one(9.4). Therefore you should do your dump and
>>> restore
>>> using the pg_dump.exe and pg_restore.exe from the Bitanami
>>> bin
>>> directory. I would cd to the above directory and do:
>>>
>>> pg_dump -V
>>> pg_restore -V
>>>
>>> to make sure the programs are found and are the 9.4
>>> versions.
>>>
>>> Then do:
>>>
>>> pg_dump -Fc -p 5432 -U postgres -f irll_project.out
>>> irll_project
>>>
>>> pg_restore -U postgres -p 5532 irll_project.out
>>>
>>>
>>> It appeared to work with this method, but it has now been
>>> running for
>>> almost 4 hours with no result. The db is not that large
>>> (probably v.
>>> small by most standards) and the .out file is ~200mb
>>>
>>>
>>> What is running, the dump or the restore?
>>>
>>> The restore - I can see the dump .out file that was created at 16hr in
>>> the postgresql/bin folder
>>>
>>
>> So how are you determining it is running and that it is not doing
>> anything?
>>
>> What does the Postgres log for the 9.4 instance show?
>>
>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> --
>>> Adrian Klaver
>>> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com
>>> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
>>>
>>>
>>>
>>>
>>> --
>>> 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
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>
>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
>