[ADMIN] Changing locale to 1250

2010-08-31 Thread Łukasz Brodziak
Hello, The question is maybe stupid but it's a trouble to me. I would like to perform some tasks on my linux (ubuntu) using db from work unfortunatly the DB has WIN1250 encoding and the PostgreSQL in linux has UTF-8 is it possible to somehow change the server's locale as I may not change the

Re: [ADMIN] Changing locale to 1250

2010-08-31 Thread Kevin Grittner
*ukasz Brodziaklukasz.brodz...@hotmail.com wrote: I would like to perform some tasks on my linux (ubuntu) using db from work unfortunatly the DB has WIN1250 encoding and the PostgreSQL in linux has UTF-8 is it possible to somehow change the server's locale as I may not change the encoding of

Re: [ADMIN] Changing locale to 1250

2010-08-31 Thread Łukasz Brodziak
: [ADMIN] Changing locale to 1250 Are you trying to connect to a PostgreSQL server which runs on Windows using a client on Linux, or are you trying to copy the database and run your own server on Linux? What database version(s), exactly? -Kevin -- Sent via pgsql-admin mailing list (pgsql

Re: [ADMIN] Changing locale to 1250

2010-08-31 Thread Kevin Grittner
*ukasz Brodziaklukasz.brodz...@hotmail.com wrote: The version in 8.4. I'm trying to copy the database from Windows to Linux. If it is of any importance the version of Windows Postgres is 8.2 Use pg_dump from your 8.4 machine. I would use the --encoding switch when I ran pg_dump to get