Re: [ADMIN] UNIX vs Windows LC CTYPE and UPPER mu

2012-04-19 Thread Albe Laurenz
service prodat wrote: first: i hope im right here in this mailing list. Yes. My problem: We have several Postgre servers 9.0.4, one on Windows Server 2008 R2 and others on different UNIX/Linux systems. Windows: LC_CTYPE = 'German, Germany' UNIX: LC_CTYPE='de_DE.UTF-8' (so LC_COLLATE is

Re: [ADMIN] Clarification on start/stop backup

2012-04-19 Thread Albe Laurenz
Scott Whitney wrote: I'll be moving to PG9 (hopefully soon...probably 6 weeks). At that time, I'll be setting up hot-standby with streaming replication to 2 sites. Off-siting my pgdumps nightly is no longer going to be possible in the very near future, due to the size of the dumps.

Re: [ADMIN] invalid byte sequence for encoding UTF8: 0xf481 - how could this happen?

2012-04-19 Thread Albe Laurenz
Rural Hunter wrote: Do you get the error if you try Chinese settings without nlpbamboo? How can I do this? The Chinese processing is provided by nlpbamboo. Er, sorry, forget what I said. I have no experience with Chinese. I guess you should try to ask the nlpbamboo people. Is there anything

Re: [ADMIN] How to auto swtich the roles of primary and standby

2012-04-19 Thread videanuadrian
so, just to make sure that i understand: after the master failed, the slave become the new master, the you have changed postgresql.conf from master to slave and viceversa and restarted the old master as slave ? --- On Thu, 4/19/12, jenopob [via PostgreSQL]

[ADMIN] ERROR: invalid input syntax for type timestamp:

2012-04-19 Thread Kshirsagar, Swanand
Hello, I am using Postgres version 8.3.17 on one of my database server. I have received a .sql dump file from my client. Which is supposed to be taken from a Postgres 8.3.7 db. Now, I have created an empty database and I am trying to restore the .sql file with command psql command. After

Re: [ADMIN] How to auto swtich the roles of primary and standby

2012-04-19 Thread jenopob
hi we did a new shell script named recovery_config_chage.sh at standby server. the script I wanted to change the fail down postgres master config ,let it start as standby server and build the communication with the former standby now is master server,then started it by remotestart.sh the

[ADMIN] Unending DB migration

2012-04-19 Thread ЇЯЅHAÐ
Hi, We are trying to migrate from Postgres to Oracle, although our DB is gigantic but we started on Mar 14th 2012 its still running with an average of 40 records per day How can we check what is going wrong. Any memory leak, CPU issue or anything. Please help me fix it

Re: [ADMIN] Unending DB migration

2012-04-19 Thread Devrim GÜNDÜZ
On Mon, 2012-04-16 at 16:27 -0700, ЇЯЅHAÐ wrote: We are trying to migrate from Postgres to Oracle, Hmm. -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org,

Re: [ADMIN] Unending DB migration

2012-04-19 Thread Peter Steinheuser
Need more info. How is Postgres setup, what version. How are you migrating? How is Oracle setup, what version. Etc. 2012/4/16 ЇЯЅHAÐ irshad.na...@gmail.com Hi, We are trying to migrate from Postgres to Oracle, although our DB is gigantic but we started on Mar 14th 2012 its still running

[ADMIN] Urgent help required

2012-04-19 Thread Nagaraj Shindagi
Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not taken backup of the data. 1) how to take the data from the formatted harddisk. ? 2) how many

Re: [ADMIN] Urgent help required

2012-04-19 Thread Scott Mead
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi nagaraj.shind...@gmail.com wrote: Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not

Re: [ADMIN] UNIX vs Windows LC CTYPE and UPPER mu

2012-04-19 Thread Peter Eisentraut
On tor, 2012-04-19 at 10:02 +0200, Albe Laurenz wrote: After looking at the UNICODE character list I tend to agree that code point 0xB5 (MICRO SIGN) should not be converted to 0x39C (GREEK CAPITAL LETTER MU). There's 0x3BC for GREEK SMALL LETTER MU.

Re: [ADMIN] Urgent help required

2012-04-19 Thread amador alvarez
Usually the standard location for data is /var/lib/pgsql/data for postgresql 8. So try to restore this directory first and underneath. Only with that you can hopefully restore the whole system assuming that if tablespaces were creates are under the standard location. I would ask others to