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
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
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
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
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
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
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.
[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
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/
"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
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
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
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
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
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
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
16 matches
Mail list logo