Re: [ADMIN] Database Create Date

2007-01-15 Thread Negandhi, Nishith
information. Regards -Original Message- From: Jim C. Nasby [mailto:[EMAIL PROTECTED] Sent: Friday, January 12, 2007 11:01 PM To: Negandhi, Nishith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Database Create Date On Tue, Jan 09, 2007 at 09:22:49AM -0600, Negandhi, Nishith wrote: > Hi,

Re: [ADMIN] Database Create Date

2007-01-10 Thread Negandhi, Nishith
iling Lists) Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Database Create Date On Wed, Jan 10, 2007 at 19:39:09 +, "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]> wrote: > >I thought it was as well to begin with - but in "ls" on Linux there's &

Re: [ADMIN] Database Create Date

2007-01-10 Thread Bruno Wolff III
On Wed, Jan 10, 2007 at 19:39:09 +, "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]> wrote: > >I thought it was as well to begin with - but in "ls" on Linux there's > >a separate "atime" and "access" value to the "show time" parameter in > >"ls" - so if "atime" is the last access time, wh

Re: [ADMIN] Database Create Date

2007-01-10 Thread Andy Shellam (Mailing Lists)
Andy Shellam (Mailing Lists) wrote: Bruno Wolff III wrote: On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: Achilleas Mantzios wrote: I was able to find that in Fre

Re: [ADMIN] Database Create Date

2007-01-10 Thread Andy Shellam (Mailing Lists)
Bruno Wolff III wrote: On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: Achilleas Mantzios wrote: I was able to find that in FreeBSD the -U in ls (1) does the job

Re: [ADMIN] Database Create Date

2007-01-10 Thread Bruno Wolff III
On Wed, Jan 10, 2007 at 10:00:37 +0200, Achilleas Mantzios <[EMAIL PROTECTED]> wrote: > Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: > > Achilleas Mantzios wrote: > > > I was able to find that in FreeBSD the -U in ls (1) does the job. > > > However i could not fin

Re: [ADMIN] Database Create Date

2007-01-10 Thread Achilleas Mantzios
Στις Τρίτη 09 Ιανουάριος 2007 18:10, ο/η Andy Shellam (Mailing Lists) έγραψε: > Achilleas Mantzios wrote: > > I was able to find that in FreeBSD the -U in ls (1) does the job. > > However i could not find any inode creation time related info for linux > > (ext3). > > Anyone has any clue on that? >

Re: [ADMIN] Database Create Date

2007-01-09 Thread Tom Lane
Achilleas Mantzios <[EMAIL PROTECTED]> writes: > However i could not find any inode creation time related info for linux > (ext3). I don't believe it keeps that. You could possibly look at the mod time on the PG_VERSION file ... Postgres never touches that after DB creation. This is not, however

Re: [ADMIN] Database Create Date

2007-01-09 Thread Andy Shellam (Mailing Lists)
Achilleas Mantzios wrote: I was able to find that in FreeBSD the -U in ls (1) does the job. However i could not find any inode creation time related info for linux (ext3). Anyone has any clue on that? I believe "ls -l" by default shows the created time, you can switch to show the last modif

Re: [ADMIN] Database Create Date

2007-01-09 Thread Achilleas Mantzios
Στις Τρίτη 09 Ιανουάριος 2007 17:36, ο/η Andy Shellam (Mailing Lists) έγραψε: > Negandhi, Nishith wrote: > > Hi, > > I need to know the create date of databases on PosegreSQL. > > PG_DATABASE does not provide this information. > > Are there any other system catalogs that can provide the above > > i

Re: [ADMIN] Database Create Date

2007-01-09 Thread Negandhi, Nishith
Well..thats one way, however I only hv access to the web interface (i.e. phpAdmin). -Original Message- From: Andy Shellam (Mailing Lists) [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 09, 2007 9:37 AM To: Negandhi, Nishith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Database

Re: [ADMIN] Database Create Date

2007-01-09 Thread Andy Shellam (Mailing Lists)
Negandhi, Nishith wrote: Hi, I need to know the create date of databases on PosegreSQL. PG_DATABASE does not provide this information. Are there any other system catalogs that can provide the above information?? Thanks !DSPAM:37,45a3b385137101969839670! I'm sure there is (not known to me atm)