[ADMIN] Logging query for Postgresql 8.1

2007-05-21 Thread Ritu Khetan
Hello, I have a few queries regarding logging in Posgtresql 8.1 on windows: 1) Is the -l option same as using the log_directory and log_filename attributes in postgresql.conf (assuming redirect_stderr is on). 2) Is it ok to not see the -l details in the properties of Postgres service in the

Re: [ADMIN] WAL FILES

2007-05-21 Thread Kis János Tamás
2007. május 17. 13.12 dátummal Khan, Mahmood Ahram ezt írta: > > And my archive_command looks like this ( archive_command copy > c:\Program Files\PostgreSQL\8.2\data\pg_xlog d:\archive\ ) > > But it is loading the files in pg_xlogs folder itself. So Can > anybody have idea about this. > Did

[ADMIN] FATAL: could not read statistics message: Connection refused

2007-05-21 Thread Nicolas Lê
Hi, I recently came upon this error message on one of our 8.1.1 server : FATAL: could not read statistics message: Connection refused Any ideas on what could possibly be the cause of this ? Some search on the lists shows a similar error : FATAL: could not read statistics message: Resource te

[ADMIN] Size of logfiles

2007-05-21 Thread Peter Elmers
Hi! I have searched the web and am sorry to say that i found nothing about the default behavior of the log files of postgres. Can anyone tell me when postgres will delete the logfiles or what postgres automatically do with them? Best regards, Peter ---(end of br

Re: [ADMIN] ERROR: invalid memory alloc request size

2007-05-21 Thread Johann Spies
On Fri, May 18, 2007 at 11:10:21AM -0400, Tom Lane wrote: > That's because it is the same :-(. You forgot to install the debuggable > executable, or something like that. > Well, I did install it and I did restart postgresql. Then I don't know any way forward. I have tried the same process on a ne

Re: [ADMIN] ERROR: invalid memory alloc request size

2007-05-21 Thread Tom Lane
Johann Spies <[EMAIL PROTECTED]> writes: > On Fri, May 18, 2007 at 11:10:21AM -0400, Tom Lane wrote: >> That's because it is the same :-(. You forgot to install the debuggable >> executable, or something like that. >> > Well, I did install it and I did restart postgresql. Then I don't know > any

Re: [ADMIN] Size of logfiles

2007-05-21 Thread Peter Eisentraut
Am Montag, 21. Mai 2007 15:38 schrieb Peter Elmers: > I have searched the web and am sorry to say that i found nothing > about the default behavior of the log files of postgres. That's easy: By default, postgres doesn't write a log file. There are about half a dozen ways to set this up, though.

Re: [ADMIN] Size of logfiles

2007-05-21 Thread Chris Browne
[EMAIL PROTECTED] (Peter Elmers) writes: > I have searched the web and am sorry to say that i found nothing > about the default behavior of the log files of postgres. > > Can anyone tell me when postgres will delete the logfiles or what > postgres automatically do with them? Can you be a bit more

[ADMIN] trouble restarting a server

2007-05-21 Thread Peter Koczan
Hi all, I'm having some trouble restarting a long-running server. Basically, pg_ctl can't kill any processes waiting on a notify interrupt. Here's what happened after trying a "stop -m fast" [EMAIL PROTECTED] ~]# ps axvw | grep post 3606 ?S 3:30 23 3260 41575 6644 0.1 /usr/bin/

Re: [ADMIN] trouble restarting a server

2007-05-21 Thread Tom Lane
"Peter Koczan" <[EMAIL PROTECTED]> writes: > [ lots of processes stuck in "notify interrupt" code ] That's weird. If it's still in that state, or if you can reproduce it, could you attach to a few of those processes with gdb and get stack traces? Looking at the async.c code, an obvious candidate

[ADMIN] Can I restrict backups?

2007-05-21 Thread Andreas
Hi, now this might be a bit of a silly question, but I'll give it a shot anyway. I'm working on a remote database for a few employees of a rather small startup company where at least a few will get teleworking jobs. They'll get a ms-access application that connects via ODBC from their home. T

Re: [ADMIN] Moving data directory

2007-05-21 Thread Linux Geeks
Hi Ray, Sorry for late reply. Yes, I have tested your instructions and working well. The think is now I need to configure so that it will always automically start with the new location. Thank you very much for the detailed instructions, really appreciated it. Regards, Dino On 5/14/07, Ray Ste

Re: [ADMIN] Moving data directory

2007-05-21 Thread Vishal Arora
Each time you start postgres server using pg_ctl you have to mention the data directory location using -D option. Alternatively you can specify in the data_directory parameter of postgresql.conf file. - vishal From: "Linux Geeks" <[EMAIL PROTECTED]> To: "Ray Stell" <[EMAIL PROTECTED]> CC: pg

Re: [ADMIN] an old version

2007-05-21 Thread Vishal Arora
you can download it from ftp://ftp-archives.postgresql.org/pub/source/v8.2.1/ - vishal From: Devrim GÜNDÜZ <[EMAIL PROTECTED]> To: Islam Hegazy <[EMAIL PROTECTED]> CC: pgsql-admin@postgresql.org Subject: Re: [ADMIN] an old version Date: Fri, 18 May 2007 08:15:39 +0300 On Thu, 2007-05-17 at 1

Re: [ADMIN] Moving data directory

2007-05-21 Thread Khan, Mahmood Ahram
No needs to specify in pg_ctl start/stop clause instead add a variable in PATH. PG_DATA = d:\postgresdata\data. It is start by just typing pg_ctl start/stop. Thanks & Best Regards M.AHRAM KHAN -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vishal Arora

Re: [ADMIN] Moving data directory

2007-05-21 Thread Vishal Arora
This is also an alternative that can be used. I am not sure about windows, but it is PGDATA variable in Linux. it can be set using export command. - vishal From: "Khan, Mahmood Ahram" <[EMAIL PROTECTED]> To: "Vishal Arora" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> CC: Subj