On Wed, 18 Jun 2008, Klint Gore wrote:
> You copied the files without stopping the database? move 4 to 2.
Klint,
Yes, actually. There was no activity on any of the databases.
> Is there an initdb in here somewhere? Or is the 8.3 server trying to start
> with an 8.1 file structure?
Ah, yes. I missed stating that. I switched to user postgres and ran:
postgres@salmo:/var/lib/pgsql$ initdb -D ./data/
The files belonging to this database system will be owned by user
"postgres".
This user must also own the server process.
The database cluster will be initialized with locales
COLLATE: C
CTYPE: en_US
MESSAGES: en_US
MONETARY: en_US
NUMERIC: en_US
TIME: en_US
could not determine encoding for locale "en_US": codeset is "ANSI_X3.4-1968"
initdb: could not find suitable encoding for locale en_US
Rerun initdb with the -E option.
Try "initdb --help" for more information.
But, using the -E option with en_US tells me that it's not a valid locale.
Thanks,
Rich
--
Richard B. Shepard, Ph.D. | Integrity Credibility
Applied Ecosystem Services, Inc. | Innovation
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863
