Re: [ADMIN] Database Create Date

Στις Τρίτη 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] What library uses postmaster when lib postgres files

The Libraries used are solved by the liker. Try ldd to show the paths of the library that needs. You can say to the linker where it can find your libraries (man ld). Example 1: default paths from a default paths PostgreSQL installation. $ ldd /usr/bin/psql libpq.so.3 => /usr/lib/libpq.

[ADMIN] IDENT authentication with md5 fallback

Hello, I was wondering if there is a way I can set up my pg_hba.conf to allow "ident sameuser" authentication, but fall back to "md5" if it fails. I would like users to be able to login to their databases (which correspond to their usernames and ident responses), however when they need to us

[ADMIN] Unsubscribe

- Need a quick answer? Get one in minutes from people who know. Ask your question on Yahoo! Answers.

[ADMIN] vacuum very slow

Normally, when I run a vacuumdb -a, the ps auxxw command shows how long the VACUUM has been running, and is normally accurate. I am noticing that ps auxxw is showing VACUUM to be running for only half the elapsed time. Does this indicate a problem with the running of vacuumdb? How can I watch the

[ADMIN] Pg_dump postgreSQL 8.1.3-1 and win2k

I'm trying to dump a schema and I receive this error : pg_dump: Error message from server: ERROR: permission denied for relation pg_ts_dict pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE pg_dump: *** aborted because of error The schema was created by a superuser "X"

[ADMIN] Lob datatype

Hi people, I was reading the documentation about PG, but I didn't find out what the Lob datatype to store images, etc. And what's the limitation to user that. Could you help me? Thank you. Alexander ___ Yahoo! Mail - Sempre a

Re: [ADMIN] Database Create Date

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

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

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

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

Guys..I don't hv access to the server directely. Is it possible to get the DB creation date from the system catalog.?? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Wednesday, January 10, 2007 2:16 PM To: Andy Shellam (Mailing Li

[ADMIN] truncate parent table

Can one safely issue a truncate command on a parent table and not affect any of the child table's data? (assuming there is data in the parent table that is not needed)