From: | "Birchall, Austen" <austen(dot)birchall(at)metoffice(dot)gov(dot)uk> |
---|---|
To: | Payal Singh <payal(at)omniti(dot)com> |
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 19:07:15 |
Message-ID: | 4E154FB60786D74BB4DFDC97BF991CAC0708F620@EXXCMPD1DAG2.cmpd1.metoffice.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Strangely when I tried it previously it listed a few tables but no data was loaded – now it just hangs
Austen
Austen Birchall Senior Database Administrator
Met Office FitzRoy Road Exeter EX1 3PB United Kingdom
Tel: +44 (0)1392 884481 Fax: +44 (0)1392 885681
E-mail: austen(dot)birchall(at)metoffice(dot)gov(dot)uk Website: http://www.metoffice.gov.uk
From: Payal Singh [mailto:payal(at)omniti(dot)com]
Sent: 15 July 2015 19:26
To: Birchall, Austen
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] pg_restore hangs for en_US.utf8 in the UK
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<mailto: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<mailto:pgsql-novice(at)postgresql(dot)org>)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-07-16 00:35:49 | Re: pg_restore hangs for en_US.utf8 in the UK |
Previous Message | Payal Singh | 2015-07-15 18:26:20 | Re: pg_restore hangs for en_US.utf8 in the UK |