thanks for replies everyone
platform is Debian 2.6 btw
Heres how i got temp fix (i dont have much background in postgresql, so dont
kick me hard):
few months ago old admin upgraded to 6GB of ram and increased shared_buffers
in posgresql.conf from 16384 to 393216 (3GB)
He also modifed sysctl to lo
From: Julio Leyva <[EMAIL PROTECTED]>
To:
Subject: [ADMIN] alter sequence in a function
Date: Tue, 3 Jul 2007 22:48:30 +
Hi allI'm trying to create a function that alters a sequenceThis what I'm
doingcreate or replace function updatesafe() returns integer AS
$$DECLAREmaxseq integer;a
hi all
by unknown reason our database server rebooted couple hours ago.
now i cannot restart posgresql 8.1
heres the error code i get:
=
[EMAIL PROTECTED]:/var/run# /etc/init.d/postgresql-8.1 start
Starting PostgreSQL 8.1 database server: mainTh
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> [EMAIL PROTECTED] writes:
>>> heres my sysctl:
>>> kernel.shmmax=4294967296
>>> kernel.shmall=536870912
>>
>> Why have you got SHMALL set to half a GB when you have Postgres
>> configured to ask for over 3 GB?
> Hmm, isn't shmall mea
Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > 2007-07-03 19:20:42 EDT 2928 FATAL: could not create shared memory
> > segment: Invalid argument
> > 2007-07-03 19:20:42 EDT 2928 DETAIL: Failed system call was
> > shmget(key=5432001, size=3276259328, 03600).
> > 2007-07-03 19:20:42 EDT 2928 HIN
[EMAIL PROTECTED] writes:
> 2007-07-03 19:20:42 EDT 2928 FATAL: could not create shared memory
> segment: Invalid argument
> 2007-07-03 19:20:42 EDT 2928 DETAIL: Failed system call was
> shmget(key=5432001, size=3276259328, 03600).
> 2007-07-03 19:20:42 EDT 2928 HINT: This error usually means
Hi allI'm trying to create a function that alters a sequenceThis what I'm
doingcreate or replace function updatesafe() returns integer AS
$$DECLAREmaxseq integer;alterseq varchar(256);thumb integer;newvalue
integer;BEGINnewvalue := 10010; maxseq := (select max(safeoperationid) from
safeopenc
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Here is the table structure for the table with all the inserts
id(PK)integer
dateinserted datetime without timezone
dateexamined datetime without timezone
lockedby integer
done boolean
failedboolean
invalid boolean
select * from table limit 1;
id | d
I was wondering if you guys have some suggested settings for our server, i
think we are not hardware limited but the configureation is set up
incorrectly. For some reason our database seems to have trouble handling
5-10+ inserts per second which seems to be a pretty trivial load for this
hardware
Dear Vishal,
Its working fine...Thanks lot...
Thanks & Regards
Jayakumar M
-Original Message-
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 03, 2007 2:12 PM
To: Jayakumar_Mukundaraju
Subject: Re: [ADMIN] pg_hba.conf issue
Is it working now?
>From: "Jayakumar_Mukun
Hi Vishal,
Thanks for the guidline.. I changed in pg_hba.conf as 172.16.85.243/32... I
created one superuser as postgres, I am using that user id only.
Thanks & Regards
Jayakumar M
-Original Message-
From: Vishal Arora [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 03, 2007 12:57 PM
To
Where is the entry for client machine with IP 172.16.85.243 ? I can see an
entry for
hostall all 172.16.82.243/32md5
It should be
hostall all 172.16.85.243/32md5
Please check that.
- Vishal
From: "Jayakumar_Mukundaraju" <[EMAIL PROTECTED]>
To: "Visha
Hi friends,
I herewith paste my pg_hba.conf file for your reference. This is in
172.16.84.76 system(Server box)
TypeDatabase User IP-Address Method
hostall all 127.0.0.1/32md5
hostall all 172.16.84.239/32trust
hostall all 172.16.
From: Ritu Khetan <[EMAIL PROTECTED]>
To: Tom Lane <[EMAIL PROTECTED]>
CC: pgsql-admin@postgresql.org,[EMAIL PROTECTED]
Subject: Re: [ADMIN] pg_hba.conf issue
Date: Tue, 3 Jul 2007 11:01:10 +0530
What does ::1/128 signify?
Its the IPv6 notification to loopback address. In other words it is
15 matches
Mail list logo
