Re: [ADMIN] UNIX vs Windows LC CTYPE and UPPER mu
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 too) on both systems ENCODING = 'UTF8' Now the function UPPER('µ') works right on Windows, giving me 'µ' (unicode = 181 respectivly U+00B5). On Unix I get a char like M (unicode = 924 respectivlyU+039C), the GREEK CAPITAL LETTER MU But we are not in Greek. Is this a Unix based problem with a wrong local setup (we dont think so, servers local working on other german letters like ä, ö, ü and UPPER too), or a Unix local problem in principle, or a wrong postgre server setup, or a postgre bug? Or is this a feature, not a bug. We dont know where to search or where to fix something. PostgreSQL uses the operating system's towupper(3) function to convert letters to upper case. 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. Bug or not, the operating systems seem to differ on this. It is not PostgreSQL's doing. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Clarification on start/stop backup
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. So...what I had planned to do was setup my production 9.x, setup my streaming standby (same network) 9.x and setup my disaster off-site (here at the office) also 9.x. Each one will do pg_dump at some point (nightly, probably) to ensure that I've got actual backup files available at each location. Yes, they'll be possibly-inconsistent, but only with one another, and that's a very minor issue for the dump files. Now, when I do the directory rsync/tar (in this case tar), I can bring it up pretty quickly on the standby that is there at the data center. However, of course, I need to also set it up here at my office. Which amounts to me driving back to the office, copying it over, and starting up PG (assuming I don't get interrupted 20 times walking in the door). So...something like this: SELECT pg_start_backup() tar off my pg directory SELECT pg_stop_backup() My question is this: Can I do stop_backup after I've tgzed to an external hard drive or do I have to wait to do stop_backup until both slaves are actually online? I _think_ that I'm merely telling the source db server that I have my possibly-inconsistent file system backup, you can go back to what you were doing, and then when the slave(s) come up, they start replaying the WAL files until they catch up then use network communication to stay in sync. Is that a correct understanding of the process? Roughly, yes. You can run pg_stop_backup() as soon as your tar command is done. You will need all archived WAL files to be copied over to the standby machine as soon as they are written. They are necessary for the standby to catch up to the master. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] invalid byte sequence for encoding UTF8: 0xf481 - how could this happen?
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 about encodings in the documentation? Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] How to auto swtich the roles of primary and standby
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] ml-node+s1045698n5650704...@n5.nabble.com wrote: From: jenopob [via PostgreSQL] ml-node+s1045698n5650704...@n5.nabble.com Subject: Re:Re: How to auto swtich the roles of primary and standby To: videanuadrian videanuadr...@yahoo.com Date: Thursday, April 19, 2012, 5:34 AM 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 serverand build the communication with the former standby now is master server,then started it by remotestart.sh the above hopes to help you something At 2012-04-17 13:42:50,videanuadrian [via PostgreSQL] [hidden email] wrote: Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5645680.html To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5650704.html To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5651436.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
[ADMIN] ERROR: invalid input syntax for type timestamp:
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 few GBs of restoration, I am getting an error - ALTER TABLE SET SET ERROR: invalid input syntax for type timestamp: CONTEXT: COPY job_step_history, line 16211941, column start_time: I tried printing this line no - 16211941 from the .sql dump file with command - sed -n 16211941 p filename.sql . The row has values - 173385251 309 6 205636 2009-09-04 22:02:46.199 1 2009-09-04 22:02:46.198 1 \N What can be the possible cause for this error? Please help. Regards, Swanand
Re: [ADMIN] How to auto swtich the roles of primary and standby
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 above hopes to help you something At 2012-04-17 13:42:50,videanuadrian [via PostgreSQL] ml-node+s1045698n5645680...@n5.nabble.com wrote: Hi there, i have the exact same problem. Did you find a solution for this ? thanks, Adrian Videanu If you reply to this email, your message will be added to the discussion below: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5645680.html To unsubscribe from How to auto swtich the roles of primary and standby, click here. NAML -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp4546630p5650704.html Sent from the PostgreSQL - admin mailing list archive at Nabble.com.
[ADMIN] Unending DB migration
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
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, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [ADMIN] Unending DB migration
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 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 -- Peter Steinheuser psteinheu...@myyearbook.com
[ADMIN] Urgent help required
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 folders or files will be their at base folder. When we install postgresql 8.2? 3) how to identify which folder contain which file. ? Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi
Re: [ADMIN] Urgent help required
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 taken backup of the data. 1) how to take the data from the formatted harddisk. ? If you have formatted your system, then your data is gone. You may have luck with some data-recovery service. 2) how many folders or files will be their at base folder. When we install postgresql 8.2? You need the PostgreSQL 'data' directory and *all *the files underneath. 3) how to identify which folder contain which file. ? That depends on where you you downloaded postgres from and which platform you are on. --Scott Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi
Re: [ADMIN] UNIX vs Windows LC CTYPE and UPPER mu
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. http://www.unicode.org/Public/UNIDATA/UnicodeData.txt has: 00B5;MICRO SIGN;Ll;0;L;compat 03BCN;;;039C;;039C and 039C;GREEK CAPITAL LETTER MU;Lu;0;L;N03BC; So this mapping is correct. Case conversion is not necessarily round-trip. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Urgent help required
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 make sure there are no backups, sometimes there is guy who knows... Good luck A.A. On 04/19/2012 10:47 AM, Nagaraj Shindagi 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 taken backup of the data. 1) how to take the data from the formatted harddisk. ? 2) how many folders or files will be their at base folder. When we install postgresql 8.2? 3) how to identify which folder contain which file. ? Please help it is very urgent. thanks and regards -- Nagaraj V Shindagi -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin