From: | Payal Singh <payal(at)omniti(dot)com> |
---|---|
To: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: pg_restore hangs for en_US.utf8 in the UK |
Date: | 2015-07-15 18:26:20 |
Message-ID: | CANUg7LCTutwHjxX9F61B+_FspobO2jrPE4z6BgXKz576bDsVWw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Since you're using the verbose option, does it hang/stop while restoring a
particular table on every try? Anything peculiar about the last couple of
line in the verbose output before it hangs?
Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253
On Wed, Jul 15, 2015 at 11:59 AM, Birchall, Austen <
austen(dot)birchall(at)metoffice(dot)gov(dot)uk> wrote:
> Hi
>
> I have the following db:
>
> Name | Owner | Encoding | Collate | Ctype | Access
> privileges
>
> -----------+----------+----------+------------+------------+-----------------------
> ***db | postgres | UTF8 | en_US.utf8 | en_US.utf8 |
>
>
> Running on RedHat Linux 6 in the UK
> ?
>
>
> Trying to restore the data after restoring the tables etc. from a
> pg_dumpall out.sql type file using
> pg_restore -d ***db_database_dump201507131900 -v
>
> just hangs
>
> Is this some kind of conflict between database and host settings?
>
> If not any other ideas?
>
> Many thanks
>
> Austen
>
> Austen Birchall Senior Database Administrator
> Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>
From | Date | Subject | |
---|---|---|---|
Next Message | Birchall, Austen | 2015-07-15 19:07:15 | Re: pg_restore hangs for en_US.utf8 in the UK |
Previous Message | Birchall, Austen | 2015-07-15 15:59:25 | pg_restore hangs for en_US.utf8 in the UK |