Re: [GENERAL] Postgres 8.4 stopped working---Please urgent help needed

On Sun, Jun 9, 2013 at 3:34 AM, wrote: > Hi All, > > > > I have a problem with PostgreSQL 8.4. It was working perfectly fine but > after the restart (within a couple of minutes) of my system whenever I > login to PostgreSQL 8.4 (localhost:5432) it gives error as under: > > > > *Server doesn't

Re: [GENERAL] Postgres 8.4 stopped working---Please urgent help needed

On Sun, Jun 9, 2013 at 6:04 AM, wrote: > Hi All, > > > > I have a problem with PostgreSQL 8.4. It was working perfectly fine but > after the restart (within a couple of minutes) of my system whenever I > login to PostgreSQL 8.4 (localhost:5432) it gives error as under: > > > > *Server doesn't

[GENERAL] Postgres 8.4 stopped working---Please urgent help needed

Hi All, I have a problem with PostgreSQL 8.4. It was working perfectly fine but after the restart (within a couple of minutes) of my system whenever I login to PostgreSQL 8.4 (localhost:5432) it gives error as under: Server doesn't listen The server doesn't accept connections: the connection l

Re: [GENERAL] Postgres 8.4 on OpenIndiana would not shutdown

On Fri, Oct 26, 2012 at 12:46 PM, Tom Lane wrote: > Boris Epstein writes: > > The Postgres 8.4 would simply not shutdown for me. Don't know why: > > > Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly > > corresponding to these shutdown attempts: > > > LOG: database system was

Re: [GENERAL] Postgres 8.4 on OpenIndiana would not shutdown

Boris Epstein writes: > The Postgres 8.4 would simply not shutdown for me. Don't know why: > Here's a snippet of /var/postgres/8.4/data_64/server.log seemingly > corresponding to these shutdown attempts: > LOG: database system was shut down at 2012-10-25 13:49:14 EDT > LOG: database system is

[GENERAL] Postgres 8.4 on OpenIndiana would not shutdown

Hello listmates, When I run the following: postgres@zeus:~$ export PGDATA=/var/postgres/8.4/data_64/ postgres@zeus:~$ /usr/postgres/8.4/bin/amd64/pg_ctl stop waiting for server to shut down... failed pg_ctl: server does not shut down p

Re: [GENERAL] Postgres 8.4: archive_timeout vs. checkpoint_timeout

Hi, Thanks for your response. Am 07.10.2011 22:05, schrieb Derrick Rice: > On Thu, Oct 6, 2011 at 3:47 AM, Frank Lanitz > wrote: > > Hi folks, > > I want to refer to a question Rob did back in 2008 at > http://archives.postgresql.org/pgsql-general/2008

Re: [GENERAL] Postgres 8.4: archive_timeout vs. checkpoint_timeout

On Thu, Oct 6, 2011 at 3:47 AM, Frank Lanitz wrote: > Hi folks, > > I want to refer to a question Rob did back in 2008 at > http://archives.postgresql.org/pgsql-general/2008-07/msg01167.php as we > are currently running into a similar question: > We are using warm standby via PITR using a shared

[GENERAL] Postgres 8.4: archive_timeout vs. checkpoint_timeout

Hi folks, I want to refer to a question Rob did back in 2008 at http://archives.postgresql.org/pgsql-general/2008-07/msg01167.php as we are currently running into a similar question: We are using warm standby via PITR using a shared drive between master and slave node. Our setup currently is set

Re: [GENERAL] Postgres 8.4 segfaults on CentOS 5.5 (using EnterpriseDB installers)

Dear Steve, Thanks for your suggestions! I ended up switching from the Enterprise DB installer to the Postgres PGDG84 YUM repository, since (a) it provides PostgreSQL 8.4.4 AND Slony 1.x (unlike Enterprise DB installer which only has Slony 2.0.2 which has a potential data loss problem), and n

Re: [GENERAL] Postgres 8.4 segfaults on CentOS 5.5 (using EnterpriseDB installers)

On 06/04/2010 06:28 PM, Aleksey Tsalolikhin wrote: Hi. ... Now we have our first CentOS 5.5 server (64-bit) and I installed PostgreSQL 8.4.4 using the EnterpriseDB installer, and it is unable to start the database instance. If I try to start it manually, I get a Segmentation Fault. I tri

[GENERAL] Postgres 8.4 segfaults on CentOS 5.5 (using EnterpriseDB installers)

Hi. We've been running PostgreSQL 8.4.2 on CentOS 5.4 (64-bit), installed with the EnterpriseDB installer. This has been excellent. Now we have our first CentOS 5.5 server (64-bit) and I installed PostgreSQL 8.4.4 using the EnterpriseDB installer, and it is unable to start the database ins

Re: [GENERAL] Postgres 8.4 Segfault on xpath

Frank jansen wrote: > Now with 8.4.3 the scripts work, but only until it has eaten up my > memory (4 gig). > The function above is executed for ~4 items, with iteration > steps of 300 items, every step memery consumption is increasing till > the machine hangs and process dies. Can you describ

Re: [GENERAL] Postgres 8.4 Segfault on xpath

Am 15.03.2010 12:56, schrieb Magnus Hagander: On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine wrote: Frank jansen writes: I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib directory, tried Debians 8.4 backport package with the 8.4 contrib package and all do

Re: [GENERAL] Postgres 8.4 Segfault on xpath

On Mon, Mar 15, 2010 at 11:47, Dimitri Fontaine wrote: > Frank jansen writes: >> I tried postgres 8.4.0 and 8.4.2 self compiled with  elf compiled contrib >> directory,  tried Debians 8.4 backport package with the 8.4 contrib package >> and all do the same: Segfault and terminated by Signal 11 :-

Re: [GENERAL] Postgres 8.4 Segfault on xpath

Frank jansen writes: > I tried postgres 8.4.0 and 8.4.2 self compiled with elf compiled contrib > directory, tried Debians 8.4 backport package with the 8.4 contrib package > and all do the same: Segfault and terminated by Signal 11 :-( Try 8.4.3, which has some XML crash related fix: http://

[GENERAL] Postgres 8.4 Segfault on xpath

Hi, I am trying to migrate a 32-Bit server running Postgres 8.3.1 to another machine running 8.4.0 on 64-bit. I have compiled Postgres 8.4.2 on a Debian Leeny 64-Bit System and getting constantly Segmentation Faults (Terminated Postgres Server by Signal 11) when a specific function, which use

Re: [GENERAL] Postgres 8.4

2009/11/29 Yasser Shakoor : > Hi > I am using postgres 8.4 but couldnot able to use the OLAP functionality can > you please advice do i have apply any patch for this. > I am using postgres on windows and downloaded the latest version from > Enterprise DB site. > Regards, > Yasser What exactly is "

Re: [GENERAL] Postgres 8.4 literal escaping

Andreas escribió: > Hi, > I've got a similar issue with a function that uses regular-expression-magic. > I got it from the sql list and it works but I'm just about 75% aware of how. > Still PG complains about those \\ everywhere. > > Replacing every \ by || E'\\' || would make it ... cough ...

Re: [GENERAL] Postgres 8.4 literal escaping

Hi, I've got a similar issue with a function that uses regular-expression-magic. I got it from the sql list and it works but I'm just about 75% aware of how. Still PG complains about those \\ everywhere. Replacing every \ by || E'\\' || would make it ... cough ... not looking cuter as it all

Re: [GENERAL] Postgres 8.4 literal escaping

On Jul 9, 2:18 pm, t...@sss.pgh.pa.us (Tom Lane) wrote: > Niederland writes: > > SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1 > > Functions without escaping literal > > Really?  I get > > regression=# select ('A' || '\r\n' || 'B') as tt from customer limit 1; > WARNING:  nonsta

Re: [GENERAL] Postgres 8.4 literal escaping

Niederland writes: > SQL 2: select ('A' || '\r\n' || 'B') as tt from customer limit 1 > Functions without escaping literal Really? I get regression=# select ('A' || '\r\n' || 'B') as tt from customer limit 1; WARNING: nonstandard use of escape in a string literal LINE 1: select ('A' || '\r\n'

[GENERAL] Postgres 8.4 literal escaping

with Postgres 8.4: SQL 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0; generates: WARNING: nonstandard use of escape in a string literal LINE 1: update customer set note = ('A' || '\r\n' || 'B') where 1=0; ^ HINT: Use the escape string