Re: [GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-24 Thread Michael Paquier
On Thu, Apr 24, 2014 at 7:44 AM, Sergey Konoplev gray...@gmail.com wrote: On Wed, Apr 23, 2014 at 10:26 AM, Kal Black kalob...@gmail.com wrote: I am trying to figure out if wal archiving from a standby is possible and a viable option for a backup strategy on Postgresql 9.3. The idea is to be

Re: [GENERAL] Request for Unsubscribe

2014-04-24 Thread Amit Langote
On Thursday, April 24, 2014, Bhim Kumar bhimkuma...@gmail.com wrote: Hi sir, I am getting a lot of mails which are tough to handle. Please unsubscribe my mail id, so that I would not get unwanted mail. Use the subscribe/unsubscribe form here.

[GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Oscar Calderon
Hi, have a nice day everybody. Yesterday i took the PostgreSQL Associate Exam, and fortunately i got 76% in my exam (there are some topics that i still have to study and practice more) so i got the certification. I received an email with my score and a PDF diploma. That's nice, but i have some

Re: [GENERAL] portable version for Usb Pen

2014-04-24 Thread Oscar Calderon
First of all, you have to format your USB as NTFS instead FAT or FAT32 because NTFS has some features needed by PostgreSQL according to this link: https://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows In the section Can I install PostgreSQL on a FAT partition?

Re: [GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Adrian Klaver
On 04/24/2014 05:08 AM, Oscar Calderon wrote: Hi, have a nice day everybody. Yesterday i took the PostgreSQL Associate Exam, and fortunately i got 76% in my exam (there are some topics that i still have to study and practice more) so i got the certification. I received an email with my score and

Re: [GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Oscar Calderon
Hi Adrian thanks for your answer, and yees, you're right, is just that i haven't received an answer from them yet, that's why i sent this email to the mail list. About requisites, those are for Associate Certification, i was asking about Professional Certification, as you can see here:

Re: [GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Adrian Klaver
On 04/24/2014 07:10 AM, Oscar Calderon wrote: Hi Adrian thanks for your answer, and yees, you're right, is just that i haven't received an answer from them yet, that's why i sent this email to the mail list. The important thing to understand here is that the Postgresql project is not

Re: [GENERAL] Request for Unsubscribe

2014-04-24 Thread Alvaro Herrera
Amit Langote wrote: On Thursday, April 24, 2014, Bhim Kumar bhimkuma...@gmail.com wrote: Hi sir, I am getting a lot of mails which are tough to handle. Please unsubscribe my mail id, so that I would not get unwanted mail. Use the subscribe/unsubscribe form here.

Re: [GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Alvaro Herrera
Adrian Klaver wrote: On 04/24/2014 07:10 AM, Oscar Calderon wrote: Hi Adrian thanks for your answer, and yees, you're right, is just that i haven't received an answer from them yet, that's why i sent this email to the mail list. The important thing to understand here is that the Postgresql

Re: [GENERAL] Got Associate Certification, what can i do or what i will going to receive?

2014-04-24 Thread Oscar Calderon
Yees, you're right. My apologizes. Regards. *** Oscar Calderon Analista de Sistemas Soluciones Aplicativas S.A de C.V www.solucionesaplicativas.com Cel.(503) 7741-7850 Tel.(503) 2522-2834 Sent from my Nexus 7 On Apr 24, 2014 8:37 AM, Alvaro Herrera

Re: [GENERAL] Request for Unsubscribe

2014-04-24 Thread Adrian Klaver
On 04/24/2014 07:34 AM, Alvaro Herrera wrote: Amit Langote wrote: On Thursday, April 24, 2014, Bhim Kumar bhimkuma...@gmail.com wrote: Hi sir, I am getting a lot of mails which are tough to handle. Please unsubscribe my mail id, so that I would not get unwanted mail. Use the

[GENERAL] Return and sql tuple descriptions are incompatible

2014-04-24 Thread Hengky Liwandouw
Hi, I have the following crosstab command : Select * from crosstab($$select produkid, warehouseid,onhand from vwtest order by 1,2$$) as t (produkid VARCHAR, warehouseid integer) vwtest : CREATE OR REPLACE VIEW public.vwtest ( produkid, warehouseid, onhand) AS

Re: [GENERAL] Patched odbc_dfw for PG = 9.2 - compiles works but has issues with NULL representation in ODBC?!?

2014-04-24 Thread Gunnar Nick Bluth
Am 19.04.2014 12:44, schrieb Gunnar Nick Bluth: Heillo, after stumbling across compile errors for odbc_fdw I realised it was still on the 9.1. level. I've patched it, based on the tds_fdw code (so it's still read-only). It does compile, and I think it is generally sane, however I'm

Re: [GENERAL] Return and sql tuple descriptions are incompatible

2014-04-24 Thread David G Johnston
Hengky Lie wrote Select * from crosstab($$select produkid, warehouseid,onhand from vwtest order by 1,2$$) as t (produkid VARCHAR, warehouseid integer) The crosstab command didn't work with error : Return and sql tuple descriptions are incompatible. I have tried to change productid type

Re: [GENERAL] WAL archiving from a standby backup strategy Postgresql 9.3

2014-04-24 Thread Sergey Konoplev
On Thu, Apr 24, 2014 at 4:37 AM, Michael Paquier michael.paqu...@gmail.com wrote: 9.3 introduced a cascading replication feature [1] that allows you to stream WAL from standbys to other standbys. Picky correction: cascading replication has been added in 9.2. Oh, right, pardon me. -- Kind

Re: [GENERAL] portable version for Usb Pen

2014-04-24 Thread John R Pierce
On 4/24/2014 5:33 AM, Oscar Calderon wrote: First of all, you have to format your USB as NTFS instead FAT or FAT32 because NTFS has some features needed by PostgreSQL according to this link: and now you have a HUGE problem.the postgres server has to run as a dedicated user, and that user

[GENERAL] Pgpool Setup inquiry - Configuration concerns

2014-04-24 Thread Burgess, Freddie
Environment: PostgreSQL 9.3.3 on RHEL 6.4 We have already configured streaming replication in our environment. We have a master/primary and two standby server configuration. Our next task requires us to configure and install pgpool. we want to leverage the installer: