| From: | Stuart Bishop <stuart(at)stuartbishop(dot)net> |
|---|---|
| To: | Don Parris <parrisdc(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Locale Issue |
| Date: | 2013-08-22 07:23:35 |
| Message-ID: | CADmi=6OcNB0wtpFZZSV-h7nJF0poheR1WazmYMFDOkyh5NSQfg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Aug 21, 2013 at 4:55 PM, Don Parris <parrisdc(at)gmail(dot)com> wrote:
> I did run pg_dropcluster, pg_createcluster (setting locale to C.UTF8) - and
> that seemed to work, except that I could not thereafter make remote
> connections (despite resetting the hba and postgres.conf files as they
> should be).
Rather than chasing locales, I'd look into why you failed here. When
you install the PostgreSQL packages, it runs pg_createcluster for you.
If you don't like the locale or encoding you used, you run
pg_dropcluster and pg_createcluster as you did. The reason why your
database did not work after doing this is probably obvious from your
log files.
--
Stuart Bishop <stuart(at)stuartbishop(dot)net>
http://www.stuartbishop.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-08-22 13:34:59 | Re: How to know detailed information about HOT(Heap-Only Tuples)? |
| Previous Message | Michael Paquier | 2013-08-22 07:16:11 | Re: Unique constraint and unique index |