Re: [ADMIN] Statistics Collector not collecting server activities

Hi Kevin, No, it is not SE-Linux and no anti-virus programs are running. I can again cross-check whether any firewall is enabled. But again if postgresql service can start without any issues, why not stats collector process the same way? Does stats collector process need any other special resou

Re: [ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

Thanks for the ideas -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent: Friday, April 09, 2010 8:03 PM To: pgsql-admin@postgresql.org; Khangelani Gama Subject: RE: [ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in t

Re: [ADMIN] initdb failure

Hi Kevin, I have checked this several times. The installer is executed by user Administrator (which apparently has all Administrator privileges) The user postgres is also being created and the data directory is owned by this user, which does have read, write, execute, modify, list folder contents

Re: [ADMIN] Handling of images via Postgressql

Devrim GÜNDÜZ wrote: > Robert Gravsjö wrote: >> I'd suggest storing meta information in PostgreSQL and the images in >> the filesystem. > > Is this transaction safe? No. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www

Re: [ADMIN] Handling of images via Postgressql

On Wed, 2010-04-07 at 16:01 +0200, Robert Gravsjö wrote: > > Do you suggest having the images in a different database by itself? > > I'd suggest storing meta information in PostgreSQL and the images in > the filesystem. Is this transaction safe? -- Devrim GÜNDÜZ PostgreSQL Danışmanı/Consultant

Re: [ADMIN] Handling of images via Postgressql

Suresh Borse skrev 2010-04-07 14.50: How does PostGreSQL perform in case we have to store and use huge no of images: Eg 4000 – 1 images, each approx 2 MB size. The Questions that we have are: How do we handle such huge no of images so that the application does not slow down? How d

Re: [ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

Khangelani Gama wrote: > the backups we have uses pg_dump command. The automatic > backup dumps file happen daily and gets saved in a certain > directory No off-site copies or archives to fall back on? If not, my ideas are: (1) I hope you made a file copy as soon as you found the problem.

Re: [ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

Hi I really mean itthe backups we have uses pg_dump command. The automatic backup dumps file happen daily and gets saved in a certain directory But the issue now is that we don't have any backup file for us to restore the database but exclude every data that got create when the date in serv

Re: [ADMIN] Admin x DBA

Renato Oliveira wrote: > I have a feeling that my questions are very much focused on Admin > side, and perhaps this list is more concerned with DBA things. > Is that the case? If so, do you guys know any postgres list > focused on Admin side? Well, the "A" in "DBA" is for "Administrator". ;-)

Re: [ADMIN] Autovacuum daemon functionality questions

Gnanakumar wrote: > >There are two separate counters for live and dead tuples, IIRC (though > >they may not be exposed in the pg_stat views) > > I've a stop/start of PostgreSQL service on a daily basis. Since these 2 > counters are not stored/saved in tables and not available in pg_stat views >

Re: [ADMIN] initdb failure

"Pankaj Mandal (pmandal)" wrote: > initdb: could not execute command > ""C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/bin/ > postgres.exe" --boot -x1 -F ": No error I would check permissions related to the user and that postgres.exe file. -Kevin -- Sent via pgsql-admin mailing list

Re: [ADMIN] archive_timeout - good indication

Renato Oliveira wrote: > What would be a good indication for 'archive_timeout' on a busy > server? The maximum amount of time for which you can tolerate lost transactions in case you need to use the backup for crash recovery. Note that you need to balance that need against the space requirem

Re: [ADMIN] WARM standby with pg_standby

Dennis Thrysøe wrote: > After copying a new dump of the MASTER cluster data and starting > the SLAVE with this data, I now get: > > Database cluster state: in production > .. > Minimum recovery ending location: 0/0 Somehow it completed archive recovery and switched over to pr

[ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

Khangelani Gama wrote: > We are still using 7.3.4 PostgreSQL Do you really mean that, or is that a typo? What sort of backups do you have? (pg_dump, file system copy, etc.) -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: htt

Re: [ADMIN] Statistics Collector not collecting server activities

"Gnanakumar" wrote: > As you said, I notice the following in postmaster log: > 2010-04-08 17:30:41 ISTLOG: could not receive test message on > socket for statistics collector: Connection refused > 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for > lack of working socket > > What

Re: [ADMIN] Statistics Collector not collecting server activities

Hi Tom, As you said, I notice the following in postmaster log: 2010-04-08 17:30:41 ISTLOG: could not receive test message on socket for statistics collector: Connection refused 2010-04-08 17:30:41 ISTLOG: disabling statistics collector for lack of working socket What is going wrong? I couldn't

Re: [ADMIN] WARM standby with pg_standby

On Fri, Apr 09, 2010 at 10:19:20AM +0200, Dennis Thrys?e wrote: > "cp: cannot stat `/psql_archive/0001.history': No such file or directory" > > By the way, one of these lines each second! > > "2010-04-09 09:09:49 IST FATAL: the database system is starting up" I asked about this a few weeks

[ADMIN] Re: database restoration problem- data became incorrect caused by incorrect date in the server

To add on to previous comments: There is only one database in the server and the backup server also has incorrect data because all the wrong data replicated to the backup server. From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin-ow...@postgresql.org] On Behalf Of Khangelani Gama Sen

[ADMIN] database restoration problem- data became incorrect caused by incorrect date in the server

Hi all I am a junior DBA: Please give an advice on how I should solve the following problem, We are still using 7.3.4 PostgreSQL but will be upgrading very soon, database is running on CentOS 5 O/S . Problem: - it's about the wrong data in the system: Everything was fine until a certain proce

Re: [ADMIN] initdb failure

Hi Jaime The installer is being executed as Administrator I have check to ensure that, it will fail otherwise before even starting to install PostgreSQL. Thanks Pankaj -Original Message- From: Jaime Casanova [mailto:jcasa...@systemguards.com.ec] Sent: Friday, April 09, 2010 12:01 AM To

Re: [ADMIN] WARM standby with pg_standby

Hi again, After copying a new dump of the MASTER cluster data and starting the SLAVE with this data, I now get: Database cluster state: in production .. Minimum recovery ending location: 0/0 Still not exactly as expected, I guess. The log says things like : "cp: cannot stat `

[ADMIN] Admin x DBA

Dear all, I have a feeling that my questions are very much focused on Admin side, and perhaps this list is more concerned with DBA things. Is that the case? If so, do you guys know any postgres list focused on Admin side? For example; PITR is my biggest concern at the moment with regards to pos

[ADMIN] archive_timeout - good indication

Dear all, What would be a good indication for 'archive_timeout' on a busy server? Thanks Renato Renato Oliveira Systems Administrator e-mail: renato.olive...@grant.co.uk Tel: +44 (0)1763 260811 Fax: +44 (0)1763 262410 www.grant.co.uk Grant Instruments (Cambridge) Lt

Re: [ADMIN] Autovacuum daemon functionality questions

>> 1. Why need to have 2 parameters (base threshold and scale factor) to define >> the threshold value, when either one of the parameter is more than enough to >> define the threshold value. Can you explain the significance of having both >> parameters. What is the real-time advantage of this? >

Re: [ADMIN] initdb failure

On Thu, Apr 8, 2010 at 7:28 PM, Pankaj Mandal (pmandal) wrote: > Hi All > > > > I have been trying to install PostgreSQL-8.4 on Windows 2000 server and keep > getting the following > > > creating template1 database in > C:/PROGRA~1/CISCOS~1/CSCONccm/objects/PostgreSQL/8.4/data/base/1 ... initdb: >

Re: [ADMIN] message during PostgreSQL 8.4.3 installation

On Fri, Apr 9, 2010 at 12:35 AM, Pankaj Mandal (pmandal) wrote: > Hi All, > > > > I see the following message > > “ > > Ensuring we can write to the data directory (using cacls): > > The data is invalid. > > “ both message you have sent, make me think your user doesn't have enough permissions --