Re: [ADMIN] 32-bit to 64-bit migration screwup

2007-10-26 Thread Dawid Kuroczko
On 10/26/07, Devrim GÜNDÜZ <[EMAIL PROTECTED]> wrote: > Hi, > > On Thu, 2007-10-25 at 22:52 -0700, David Young wrote: > > FATAL: incorrect checksum in control file > > Did you move the old data files to the new server? If so, it won't work. > Dump your 32-bit database with 32-bit binaries, and loa

Re: [ADMIN] Problem with PITR Past Particular WAL File

2007-10-26 Thread Teodor Sigaev
Craig McElroy wrote: Teodor: Thanks for the followup. We will be upgrading this system to 8.2.5 in the next day or so and will test it on that anyways just to be sure it isn't related. Let me know if there is anything else we can provide to help track down the bug. We will be keeping th

[ADMIN] PL/JAVA installation on Suse Linux

2007-10-26 Thread yogesh
Hello frnds, I have installed the Postgres on Linux Platform(suse Linux)...now i want to install Pl/JAVA in postgres..i done it with the following command. java -cp /usr/share/pljava/deploy.jar:/usr/share/pgsql/ postgresql-8.1-404.jdbc3.jar org.postgresql.pljava.deploy.Deplo

Re: [ADMIN] PL/JAVA installation on Suse Linux

2007-10-26 Thread yogesh
On Oct 26, 12:51 pm, yogesh <[EMAIL PROTECTED]> wrote: > Hello frnds, > I have installed the Postgres on Linux Platform(suse > Linux)...now i want to install Pl/JAVA in postgres..i done it with > the following command. > > java -cp /usr/share/pljava/deploy.jar:/usr/share/pgsql

[ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread David Lowry
Hi, The docs state that if there are no %-escapes in log_filename, then it will add the epoch onto the end of the log filename. Is there any way to turn off this behavior and just use the filename specified in log_filename? I'd like have all the log data written to a file like postgresql.l

Re: [ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread Peter Koczan
> The docs state that if there are no %-escapes in log_filename, then it will > add the epoch onto the end of the log filename. Is there any way to turn off > this behavior and just use the filename specified in log_filename? I'd like > have all the log data written to a file like postgresql.log an

Re: [ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Tom Lane <[EMAIL PROTECTED]> wrote: >> If logrotate would work, we'd never have bothered writing our own >> substitute. But there's no way for logrotate to repoint postmaster's >> stderr into other files. > Uh... can't we just use copytruncate with

Re: [ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread Tom Lane
David Lowry <[EMAIL PROTECTED]> writes: > The docs state that if there are no %-escapes in log_filename, then > it will add the epoch onto the end of the log filename. Is there any > way to turn off this behavior and just use the filename specified in > log_filename? I'd like have all the log

Re: [ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread Joshua D. Drake
On Fri, 26 Oct 2007 17:33:15 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > David Lowry <[EMAIL PROTECTED]> writes: > > The docs state that if there are no %-escapes in log_filename, > > then it will add the epoch onto the end of the log filename. Is > > there any way to turn off this behavior and ju

[ADMIN] Find the Person Connected to a Database

2007-10-26 Thread Naomi Walker
I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris 10 OS), but someone is connected to the database. What is the best way to find out exactly who is connected? Thanks, Naomi -- Naomi Walker

Re: [ADMIN] way to turn off epochs in log_filename

2007-10-26 Thread Joshua D. Drake
On Fri, 26 Oct 2007 17:45:00 -0400 Tom Lane <[EMAIL PROTECTED]> wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > > Tom Lane <[EMAIL PROTECTED]> wrote: > >> If logrotate would work, we'd never have bothered writing our own > >> substitute. But there's no way for logrotate to repoint > >> p

Re: [ADMIN] Find the Person Connected to a Database

2007-10-26 Thread Milen A. Radev
Naomi Walker написа: > I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris > 10 OS), but someone is connected to > the database. What is the best way to find out exactly who is connected? > select * from pg_stat_activity where datname = ; More here - http://www.postgresql.

[ADMIN] Find who is connected to a database

2007-10-26 Thread Naomi Walker
I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris 10 OS), but someone is connected to the database. What is the best way to find out exactly who is connected? Thanks, Naomi -- Naomi Walker

Re: [ADMIN] Find the Person Connected to a Database

2007-10-26 Thread Tom Lane
"Milen A. Radev" <[EMAIL PROTECTED]> writes: > Naomi Walker íàïèñà: >> I'm trying to drop a database in a postgres 8.1.4 instance (x86 Solaris >> 10 OS), but someone is connected to >> the database. What is the best way to find out exactly who is connected? > select * from pg_stat_activity wher

Re: [ADMIN] Find the Person Connected to a Database

2007-10-26 Thread Naomi Walker
Thanks for jogging my memory! Works like a charm. Naomi >> select * from pg_stat_activity where datname = ; >> > > If that doesn't work because you've got stats collection turned off, > "ps" will help too: > > http://www.postgresql.org/docs/8.1/static/monitoring.html > > On Solaris, note the