Re: [ADMIN] Backup job

2007-07-12 Thread Jayakumar_Mukundaraju
Dear Vishal, Where can i get event log Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Thu 7/12/2007 12:32 PM To: Jayakumar_Mukundaraju; [EMAIL PROTECTED] Subject: RE: [ADMIN] Backup job Could you please send me the infor

[ADMIN] Tablespace on Windpws

2007-07-12 Thread Abraham, Danny
How can I use Tablespaces on Windows? Danny Abraham CTM&D BU 972-52-4286-513 [EMAIL PROTECTED]

[ADMIN] building from source requires postgres user account

2007-07-12 Thread George Wilk
I'd like to use my own user account when building postgres from source. When I follow directions on Sun's page: http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=view I don't have a problem, but running build under my own account runs into file permission issues after the build is done. Thi

Re: [ADMIN] delayed actions

2007-07-12 Thread De Leeuw Guy
Sorry for the sound, I match a bug on my trigger :-( Guy ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Abraham, Danny

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Geoffrey
Based on how often it crashes? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin ---(end of broadcast)--- TIP 9: In versions below 8.

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Adam Witney
I assume you mean finding out the OS of the machine running PostgreSQL?? Maybe this will give a clue: db=>select version(); (I've never run it on Windows so I don't know what that produces for that OS) adam ---(end of broadcast)--- TIP 3: Have

Re: [ADMIN] building from source requires postgres user account

2007-07-12 Thread Tom Lane
"George Wilk" <[EMAIL PROTECTED]> writes: > I'd like to use my own user account when building postgres from source. > When I follow directions on Sun's page: > http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=view I don't have a > problem, but running build under my own account runs into file

Re: [ADMIN] building from source requires postgres user account

2007-07-12 Thread Peter Eisentraut
Am Donnerstag, 12. Juli 2007 16:22 schrieb George Wilk: > I'd like to use my own user account when building postgres from source. > When I follow directions on Sun's page: > http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=view I don't have a > problem, but running build under my own account r

Re: [ADMIN] building from source requires postgres user account

2007-07-12 Thread George Wilk
Tom, I fixed my build problem. Our build scenario is slightly atypical. We are building and installing postgres into a fake root directory and then creating a Solaris package for bundling with our configuration manager component. I am all set. Thanks! Cheers, ~george -Original Message-

Re: [ADMIN] building from source requires postgres user account

2007-07-12 Thread Joshua D. Drake
George Wilk wrote: I’d like to use my own user account when building postgres from source. When I follow directions on Sun’s page: http://docs.sun.com/app/docs/doc/819-5578/6n7lcpcl5?a=view I don’t have a problem, but running build under my own account runs into file permission issues after t

[ADMIN] Anyone seen this message?

2007-07-12 Thread Carol Walter
Hello, Everyone, You've been really helpful it the past; I sure hope someone knows this one. When I try to describe the tables of one of my users the system returns the message as follows: "column i.indisvalid does not exist" It doesn't give any other info. Has anyone seen this message, an

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Alvaro Herrera
Carol Walter wrote: > Hello, Everyone, > > You've been really helpful it the past; I sure hope someone knows this one. > When I try to describe the tables of one of my users the system returns > the message as follows: > "column i.indisvalid does not exist" > It doesn't give any other info. Has

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Ned Wolpert
Let me ask a further question for clarification on this point, just to be sure... though I'm going to bet I know the answer... just want to be sure. In my current production environment, the PostgreSQL database server is the latest, 8.2.4. The apps that communicate with it are planned to be runn

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Alvaro Herrera
Ned Wolpert escribió: > In my current production environment, the PostgreSQL database server > is the latest, 8.2.4. The apps that communicate with it are planned > to be running on stock CentOS5 servers, with the default 8.1.x (8.1.9) > client libraries. So, not only is psql 8.1.9 (which I don't

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Benjamin Krajmalnik
My Windows box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" My BSD box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" Seems to be the same ---(end of broadcast)

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Joshua D. Drake
Benjamin Krajmalnik wrote: My Windows box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" My BSD box says: "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)" Seems to be the same Your bsd box appears to

Re: [ADMIN] Anyone seen this message?

2007-07-12 Thread Ned Wolpert
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 This is one bet I'm glad to lose. :-) Alvaro Herrera wrote: > Ned Wolpert escribió: > >> In my current production environment, the PostgreSQL database server >> is the latest, 8.2.4. The apps that communicate with it are planned >> to be running on

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Benjamin Krajmalnik
My mistake. I was connecting to remote machines and must have accidentally issued the version on the same box :( BSD is returning: "PostgreSQL 8.1.5 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518" > -Original Message- > From: Joshua D. Drake [mailto:[EMAIL

Re: [ADMIN] How can I tell that the underlying OS is Windows?

2007-07-12 Thread Joshua D. Drake
Benjamin Krajmalnik wrote: My mistake. I was connecting to remote machines and must have accidentally issued the version on the same box :( How about this :) SELECT * FROM version() WHERE version ~* 'gcc.exe' OR version ~* 'msvc'; You probably want to replace msvc with whatever that would be

Re: [ADMIN] PgAgent Job Scheduling-Backup

2007-07-12 Thread Jayakumar_Mukundaraju
Dear Vishal, Still i am in that place only.. Kindly guide me...Give me some steps, how to automate the backup.. Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Fri 7/13/2007 9:38 AM To: [EMAIL PROTECTED]; Jayakumar_Mukundaraju

Re: [ADMIN] PgAgent Job Scheduling-Backup

2007-07-12 Thread Jayakumar_Mukundaraju
Dear Ashish, Congrats... I am trying that only.. Kindly give me the sql command use used.. Thanks & Regards Jayakumar M From: Vishal Arora [mailto:[EMAIL PROTECTED] Sent: Fri 7/13/2007 10:59 AM To: [EMAIL PROTECTED] Cc: Jayakumar_Mukundaraju Subject: Re: [AD