[ADMIN] Fw: postgres logging
Hi all, I've switched on log_statement in postgresql.conf for debugging purposes. I tried logging connections and pids as well, but I need to match up the logged statements to specific connections. The postmaster logs to a separate log file, but at the moment it's impossible to tell which sql comes from which connection. Is there an easy way to accomplish this? Kind Regards Stefan 0009.mimetmp Description: PGP signature pgp0.pgp Description: PGP signature
Re: [ADMIN] [SQL] Fw: postgres logging [SOLVED]
Stef mentioned : => The postmaster logs to a separate log file, but at the moment => it's impossible to tell which sql comes from which connection. => Is there an easy way to accomplish this? Erm... sorry , It appears my postgresql.conf is not an original. It didn't have the log_pid option in. :) pgp0.pgp Description: PGP signature
Re: [ADMIN] [PERFORM] Postgres on Netapp
D'Arcy J.M. Cain wrote: > With the price of GigE adapters I wouldn't consider anything else. > > I have a huge database that takes about an hour to copy. The netApp snapshot > feature is very nice because I can get a "moment in time" image of the > database. Even though I can't run from the snapshot because it is read only > (*) and PG needs to write to files just to open the database, I can copy it > and get a runnable version of the DB. If I copy directly from the original I > can get many changes while copying and wind up with a copy that will not run. > > (*): It would be nice if PG had a flag that allowed a database to be opened in > read only mode without touching anything in the directory. PostgreSQL has to read the WAL to adjust the contents of the flat file on startup in such a setup, so I don't see how we could do it read-only. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.| Newtown Square, Pennsylvania 19073 ---(end of broadcast)--- TIP 3: 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
[ADMIN] Linux Cluster File Systems
Anyone have good/bad experience using OpenGFS or the Sistina GFS? Any other cluster file systems out there? Greg -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: [EMAIL PROTECTED] Cranel. Technology. Integrity. Focus. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** ---(end of broadcast)--- TIP 8: explain analyze is your friend
[ADMIN] Can't connect to phppgadmin
Hi,I have Installed Postgresql 7.3 for linux suse8.2 and i try to connect topostgresql pass through phpPgAdmin 3.2 but i can't because i get message'php doesn't support database connectivity', so how can i pass through tophpPgAdmin?regards, Charlie Schaubmair
[ADMIN] Installation sunos 5.9
Trying to install 7.3.4 on a Sparc 64 sunos 5.9 box, and have followed the instructions on http://techdocs.postgresql.org/v2/Guides/Installation%20Guides/ Compiling%20PostgreSQL%207.3.2%20on%20Solaris%208%209/view to the t. However, when going to compile Postgres I'm getting the error on ./configure --prefix=/opt/pgsql: checking for fseeko... (cached) yes checking test program... failed configure: error: *** Could not execute a simple test program. This may be a problem *** related to locating shared libraries. Check the file 'config.log' *** for the exact reason. config.log is HUGE, so I'm not going to post the whole thing here, just the top 2 sections in hopes that a clue will lye within. If this isn't the area i'm looking for, please let me know. Thank you for any assistance: It was created by PostgreSQL configure 7.3.4, which was generated by GNU Autoconf 2.53. Invocation command line was $ ./configure --prefix=/opt/pgsql ## - ## ## Platform. ## ## - ## hostname = osiris uname -m = sun4u uname -r = 5.9 uname -s = SunOS uname -v = Generic_112233-07 /usr/bin/uname -p = sparc /bin/uname -X = System = SunOS Node = osiris Release = 5.9 KernelID = Generic_112233-07 Machine = sun4u BusType = Serial = Users = OEM# = 0 Origin# = 1 NumCPU = 1 /bin/arch = sun4 /usr/bin/arch -k = sun4u /usr/convex/getsysinfo = unknown hostinfo = unknown /bin/machine = unknown /usr/bin/oslevel = unknown /bin/universe = unknown PATH: /usr/local/bin PATH: /usr/bin PATH: /usr/ccs/bin ## --- ## ## Core tests. ## ## --- ## configure:1295: checking build system type configure:1313: result: sparc-sun-solaris2.9 configure:1321: checking host system type configure:1335: result: sparc-sun-solaris2.9 configure:1345: checking which template to use configure:1444: result: solaris configure:1563: checking whether to build with 64-bit integer date/time support configure:1594: result: no configure:1600: checking whether to build with recode support configure:1631: result: no configure:1638: checking whether NLS is wanted configure:1672: result: no configure:1680: checking for default port number configure:1709: result: 5432 configure:1727: checking for default soft limit on number of connections configure:1756: result: 32 configure:1947: checking for gcc configure:1963: found /usr/local/bin/gcc configure:1973: result: gcc configure:1992: checking for C compiler version configure:1995: gcc --version &5 gcc (GCC) 3.3.2 Copyright (C) 2003 Free Software Foundation, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. configure:1998: $? = 0 configure:2000: gcc -v &5 Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.8/3.3.2/specs Configured with: ../configure --with-as=/usr/ccs/bin/as --with-ld=/usr/ccs/bin/ld --disable-nls Thread model: posix gcc version 3.3.2 configure:2003: $? = 0 configure:2005: gcc -V &5 gcc: `-V' option must have argument configure:2008: $? = 1 configure:2034: checking for C compiler default output configure:2037: gcc -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include conftest.c >&5 configure:2040: $? = 0 configure:2073: result: a.out configure:2078: checking whether the C compiler works configure:2084: ./a.out configure:2087: $? = 0 configure:2102: result: yes configure:2109: checking whether we are cross compiling configure:2111: result: no configure:2114: checking for suffix of executables configure:2116: gcc -o conftest -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include conftest.c >&5 configure:2119: $? = 0 configure:2141: result: configure:2147: checking for suffix of object files configure:2171: gcc -c -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include conftest.c >&5 configure:2174: $? = 0 configure:2193: result: o configure:2197: checking whether we are using the GNU C compiler configure:2224: gcc -c -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -funroll-loops -fexpensive-optimizations -I/opt/pgsql/include conftest.c >&5 configure:2227: $? = 0 configure:2230: test -s conftest.o configure:2233: $? = 0 configure:2245: result: yes configure:2251: checking whether gcc accepts -g configure:2275: gcc -c -g -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -fu
Re: [ADMIN] [SQL] Database diagram
Dear Ganesan, pgautodoc (for dot output) + dot (from graphviz.org , creates postscript) + epssplit ( splits the postscript into multipage so that one can create poster size diagrams) works well for me. I have 45 tables in the database though. Regds mallah. Chris Travers wrote: There is a free Perl script which is called something like pgautodoc which creates DIA diagrams from databases. Take a look for it on Freshmeat. - Original Message - From: "Ganesan Kanavathy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, January 20, 2004 1:38 PM Subject: [SQL] Database diagram I have a postgres database with many tables. How do I create database diagram? Are there any free tools available to create database diagram from pgsql database? Regards, Ganesan ---(end of broadcast)--- TIP 8: explain analyze is your friend ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 3: 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] Fw: postgres logging
> The postmaster logs to a separate log file, but at the moment > it's impossible to tell which sql comes from which connection. > Is there an easy way to accomplish this? > The PID of the connected process is prepended to every log statement. You can make use of this to know which sql comes from which connection. Regards, A.Bhuvaneswaran signature.asc Description: This is a digitally signed message part