| From: | Brad Schick <schickb(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Maintenance database SQL_ASCII |
| Date: | 2009-06-12 23:52:32 |
| Message-ID: | 4A32EA40.8000206@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
After a new pgsql installation the "postgres" maintenance database has
an encoding of SQL_ASCII. pgAdmin III gave me a warning about that, and
I may want to create users or databases that are not restricted 7bit ASCII.
I was going to backup and recreate this table, but it can't be dropped.
I guess I could backup all of the other databases and start over from
"initdb", but that would be a hassle. Do I have any other options? The
strange thing is that I have two very similarly configured Ubuntu
machines and the other created the "postgres" database with UTF8 encoding.
The locale on both machines is the same:
$ locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
-Brad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | zxo102 ouyang | 2009-06-13 01:31:55 | Re: Very slow searching in a table with more than 10 millions recovered records from a backup file... |
| Previous Message | Sam Mason | 2009-06-12 23:20:12 | Re: String Manipulation |