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? > > I believe "ls -l" by default shows the created time, you can switch to > show the last modified time using "ls -l --time=atime" > No, it seems ext3 does not keep this info. (See also Tom's answer). > Also in FreeBSD (at least, 6.1) there is no "-U" option to ls; there is > a "-u" option but this shows the last access, not the creation time. It must have been introduced somewhere in the 6.1-STABLE cycle. For my dev machine (6.1-STABLE #8) "-U" support is included, whereas in my other pet machine 6.1-PRERELEASE #1 it is not. -- Achilleas Mantzios ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
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.so.3 (0x40029000) libpam.so.0 => /lib/libpam.so.0 (0x40044000) libssl.so.2 => /lib/libssl.so.2 (0x4004c000) libcrypto.so.2 => /lib/libcrypto.so.2 (0x40079000) libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x4013c000) libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40194000) libz.so.1 => /usr/lib/libz.so.1 (0x40198000) libreadline.so.4 => /usr/lib/libreadline.so.4 (0x401a6000) libtermcap.so.2 => /lib/libtermcap.so.2 (0x401cc000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x401d) libresolv.so.2 => /lib/libresolv.so.2 (0x401fd000) libnsl.so.1 => /lib/libnsl.so.1 (0x4020f000) libdl.so.2 => /lib/libdl.so.2 (0x40225000) libm.so.6 => /lib/i686/libm.so.6 (0x4022a000) libc.so.6 => /lib/i686/libc.so.6 (0x4024d000) libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40388000) libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x4039d000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x4000) Example 2: modified paths from a not default paths PostgreSQL installation. Sitefdevel:~$ ldd $HOME/opt/postgres-8.1.5/bin/psql $ echo "LD_LIBRARY_PATH=$LD_LIBRARY_PATH" LD_LIBRARY_PATH=/home/cvsitef/opt/postgres-8.1.5/lib libpq.so.4 => /home/cvsitef/opt/postgres-8.1.5/lib/libpq.so.4 (0x40018000) libz.so.1 => /usr/lib/libz.so.1 (0x40042000) libreadline.so.4 => /usr/lib/libreadline.so.4 (0x4005) libtermcap.so.2 => /lib/libtermcap.so.2 (0x40076000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x4007a000) libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000) libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000) libdl.so.2 => /lib/libdl.so.2 (0x400d) libm.so.6 => /lib/i686/libm.so.6 (0x400d4000) libc.so.6 => /lib/i686/libc.so.6 (0x400f7000) libpthread.so.0 => /lib/i686/libpthread.so.0 (0x40232000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x4000) Best regards Jorge Serván. Adam Radłowski wrote: I'm testing 8.1.3 and 8.1.6 of FC3 2.6.12 . I have installed (compiled from source) two copies of PostgreSQL: 8.1.3 - typically in /usr/local/pgsql and I have configured path to these libs (in ld.so.conf): /usr/local/pgsql/lib 8.1.6 - not typically in /usr/local/pgsql816 (I edited before installing with "make install" src/Makefile.global and I changed "prefix" for install after "configure" and "make") I never use this two versions of postmaster parallel, so I use for them this same database cluster. What libraries uses postmaster 8.1.6 in this situation ? Their own libs or taken from 8.1.3 ? Best regards Adam ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
[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 use PHP to login, they must enter a password because the ident response will be different (always "apache" I would assume). I have tried the following pg_hba.conf configurations, but I cannot seem to get this right. This results in only allowing users to login after entering the correct password: local sameuserall md5 local sameuserall ident sameuser This results in ident checking and returning FATAL without asking for a password if it fails: local sameuserall ident sameuser local sameuserall md5 So, how would I configure pg_hba.conf to work like this? Is it possible, or should I only allow md5 and not worry about ident? Please let me know. -- Dustin C. Hatch http://www.dchweb.com
[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 progress of vacuumdb Thanks Sriram
[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", and the dump has been done by another user "Y" which has the privileges : ALL on this table. grant ALL on table pg_ts_dict to Y; The owner of pg_ts_dict is "X". Thanks for your answer,
[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 melhor opção para você! Experimente já e veja as novidades. http://br.yahoo.com/mailbeta/tudonovo/ ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
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 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 modified time using "ls -l --time=atime" Just another note on this, atime is the last access time. ctime is the real last modify time, mtime is another modify time that can be changed (which is useful after backups). atime is often disabled in ext3 file systems to reduce I/O, since it isn't all that useful. ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
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. 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 modified time using "ls -l --time=atime" Just another note on this, atime is the last access time. ctime is the real last modify time, mtime is another modify time that can be changed (which is useful after backups). atime is often disabled in ext3 file systems to reduce I/O, since it isn't all that useful. 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, what's "access" mean? ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
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 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 modified time using "ls -l --time=atime" Just another note on this, atime is the last access time. ctime is the real last modify time, mtime is another modify time that can be changed (which is useful after backups). atime is often disabled in ext3 file systems to reduce I/O, since it isn't all that useful. 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, what's "access" mean? Hmm ok just done a bit of experimenting on this - "atime" and "access" show exactly the same information - "mtime" is an invalid value according to my Fedora 5 system. Confused. -- start paste -- ls -l / --time=mtime ls: invalid argument `mtime' for `--time' Valid arguments are: - `atime', `access', `use' - `ctime', `status' Try `ls --help' for more information. -- end paste -- ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
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, what's "access" mean? atime includes at least reads of the file. I don't know if it also includes writes or stats. > Hmm ok just done a bit of experimenting on this - "atime" and "access" > show exactly the same information - "mtime" is an invalid value > according to my Fedora 5 system. Confused. mtime is the time you normally see, so there may not be a separate option for it on ls. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
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 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 > >a separate "atime" and "access" value to the "show time" parameter in > >"ls" - so if "atime" is the last access time, what's "access" mean? atime includes at least reads of the file. I don't know if it also includes writes or stats. > Hmm ok just done a bit of experimenting on this - "atime" and "access" > show exactly the same information - "mtime" is an invalid value > according to my Fedora 5 system. Confused. mtime is the time you normally see, so there may not be a separate option for it on ls. ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
[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)
