Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Bhushan Pathak
I do not have any earlier versions of postgres installed, neither a parallel instance running. In the pgstartup.log file, only the segfault error is recorded, nothing else. I have downloaded the following RPMs from http://yum.postgresql.org/9.2/redhat/rhel-5.6-x86_64/

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Devrim Gündüz
Hi, On Mon, 2014-06-09 at 14:23 +0530, Bhushan Pathak wrote: A core file was not generated. Can you please also install the -debuginfo package? Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Bhushan Pathak
Trying to figure out shell environment differences between the service script postgres shell, if I comment out the following variable in profile file/add them after performing initdb operation, the postgresql operations seem to work fine - PATH=$PATH:/usr/pgsql-9.2/bin export PATH export

[GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
Please help me with this, my secondary server shows a replication problem. It stopped at the file called *00054BAF00AF** …*then from here primary server kept on sending walfiles, until the walfiles used up the disc space in the data directory. How do I fix this problem. It’s postgres

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
FilesystemSize Used Avail Use% Mounted on /dev/sda3 57G 15G 39G 28% / /dev/mapper/vg0-pgsql2 5.4T 5.3T 0 100% /pgsql2 /dev/sda1 99M 12M 83M 13% /boot tmpfs 30G 0 30G 0% /dev/shm *Disc

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
The big question we can’t answer is that when the replication was at this point (*Command for restore: cp /pgsql2/walfiles/00054BAF00B0 pg_xlog/RECOVERYXLOG* ) , it then started to say WAL file not present yet. We can’t find this *00054BAF00B0 *file any where* . *

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Adrian Klaver
On 06/09/2014 04:02 AM, Bhushan Pathak wrote: Trying to figure out shell environment differences between the service script postgres shell, if I comment out the following variable in profile file/add them after performing initdb operation, the postgresql operations seem to work fine - In the

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
Please please help *From:* Khangelani Gama [mailto:kg...@argility.com] *Sent:* Monday, June 09, 2014 1:42 PM *To:* pgsql-general@postgresql.org *Subject:* pg_standby replication problem Please help me with this, my secondary server shows a replication problem. It stopped at the file called

Re: [GENERAL] PostgreSQL 9.2.4 + CentOS 6.5 64 bit - segfault error in initdb

2014-06-09 Thread Adrian Klaver
On 06/09/2014 01:53 AM, Bhushan Pathak wrote: I do not have any earlier versions of postgres installed, neither a parallel instance running. In the pgstartup.log file, only the segfault error is recorded, nothing else. I have downloaded the following RPMs from

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Adrian Klaver
On 06/09/2014 07:28 AM, Khangelani Gama wrote: Please please help Before anyone can help you will need to provide more information on what your archiving, replication setup is. To begin: 1)Are you doing both archiving and streaming replication? 2) What are the settings in the configuration

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Alan Hodgson
On Monday, June 09, 2014 04:28:53 PM Khangelani Gama wrote: Please help me with this, my secondary server shows a replication problem. It stopped at the file called *00054BAF00AF …*then from here primary server kept on sending walfiles, until the walfiles used up the disc space in

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
-Original Message- From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alan Hodgson Sent: Monday, June 09, 2014 4:51 PM To: pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_standby replication problem On Monday, June 09, 2014 04:28:53 PM

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
I just saw got this from the primary server (/tmp/run_replication.sh.out), secondary server's IP 10.58.101.10. replication started: Sun Jun 8 00:05:26 SAST 2014 source: pg_xlog/00054BAF00AF, dest: 00054BAF00AF replication finished: Sun Jun 8 00:05:33 SAST 2014

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
-Original Message- From: Khangelani Gama [mailto:kg...@argility.com] Sent: Monday, June 09, 2014 5:26 PM To: 'Alan Hodgson'; 'pgsql-general@postgresql.org' Subject: RE: [GENERAL] pg_standby replication problem I just saw got this from the primary server (/tmp/run_replication.sh.out),

[GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
Hi All I would like to re-post the problem we have. The secondary server ran out the disc space due the replication problem (Connection Time out).Since there was a Connection time out Problem in the primary server, how can I make disc space in the secondary server for the replication to continue

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
This is the standby replication setting with archive_command sending the WALs from master to standby. -Original Message- From: Khangelani Gama [mailto:kg...@argility.com] Sent: Monday, June 09, 2014 8:06 PM To: pgsql-general@postgresql.org Subject: pg_standby replication problem Hi All

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Alan Hodgson
On Monday, June 09, 2014 08:05:41 PM Khangelani Gama wrote: Hi All I would like to re-post the problem we have. The secondary server ran out the disc space due the replication problem (Connection Time out). The secondary server would not (could not) run out of drive space due to a problem

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Adrian Klaver
On 06/09/2014 11:15 AM, Khangelani Gama wrote: This is the standby replication setting with archive_command sending the WALs from master to standby. What are the conf settings on the standby server? -- Adrian Klaver adrian.kla...@aklaver.com -- Sent via pgsql-general mailing list

[GENERAL] two questions about fulltext searchign / tsvector indexes

2014-06-09 Thread Jonathan Vanasco
I'm having some issues with fulltext searching. I've gone though the list archives and stack overflow, but can't seem to get the exact answers. hoping someone can help. Thanks in advance and apologies for these questions being rather basic. I just felt the docs and some online posts are

Re: [GENERAL] pg_standby replication problem

2014-06-09 Thread Khangelani Gama
-Original Message- From: Adrian Klaver [mailto:adrian.kla...@aklaver.com] Sent: Tuesday, June 10, 2014 1:42 AM To: Khangelani Gama; pgsql-general@postgresql.org Subject: Re: [GENERAL] pg_standby replication problem On 06/09/2014 11:15 AM, Khangelani Gama wrote: This is the standby