It's possible the restore is still building indexes.
What does it show when you run this query?
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 <[email protected]>
wrote:
> On 12/23/2015 11:09 AM, Killian Driscoll wrote:
>
>> On 23 December 2015 at 20:07, Adrian Klaver <[email protected]
>> <mailto:[email protected]>> wrote:
>>
>> On 12/23/2015 11:03 AM, Killian Driscoll wrote:
>>
>> On 23 December 2015 at 16:02, Adrian Klaver
>> <[email protected] <mailto:[email protected]>
>> <mailto:[email protected]
>> <mailto:[email protected]>>> wrote:
>>
>> On 12/23/2015 06:50 AM, Killian Driscoll wrote:
>>
>> On 23 December 2015 at 15:47, Adrian Klaver
>> <[email protected]
>> <mailto:[email protected]>
>> <mailto:[email protected]
>>
>> <mailto:[email protected]>>
>>
>>
>>
>>
>> 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
>> [email protected] <mailto:[email protected]>
>> <mailto:[email protected]
>> <mailto:[email protected]>>
>>
>>
>>
>>
>> --
>> Adrian Klaver
>> [email protected] <mailto:[email protected]>
>>
>>
>>
>
> --
> Adrian Klaver
> [email protected]
>
>
> --
> Sent via pgsql-general mailing list ([email protected])
> 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.
