Re: [ADMIN] postgres, syslog and freeBSD
Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε: Hi list; I'm trying to get postgres syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1 Here's my postgres setup log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: security.*/var/log/security auth.info;authpriv.info /var/log/auth.log mail.info /var/log/maillog lpr.info /var/log/lpd-errs ftp.info /var/log/xferlog cron.*/var/log/cron *.=debug /var/log/debug.log *.emerg * # uncomment this to log all writes to /dev/console to /var/log/ console.log #console.info /var/log/console.log # uncomment this to enable logging of all log messages to /var/log/ all.log # touch /var/log/all.log and chmod it to mode 600 before it will work #*.* /var/log/all.log # uncomment this to enable logging to a remote loghost named loghost #*.* @loghost # uncomment these if you're running inn # news.crit /var/log/news/news.crit # news.err/var/log/news/news.err # news.notice /var/log/news/news.notice !startslip *.* /var/log/slip.log !ppp *.* /var/log/ppp.log LOCAL0.* /var/log/pgsql change that to local0.*/var/log/pgsql.log (lowercase, also a .log suffix is more standard) make sure the /var/log/pgsql.log file exists (create it with vi), and then change its permissions to smth like -rw--- 1 root wheel 109274 30 Μαϊ 09:00 /var/log/pgsql.log This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1 handy at the moment. I dont see any files show up in /var/log what am I doing wrong? Thanks in advance.. /Kevin -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgres, syslog and freeBSD
did you kill -hup syslogd after you changed syslog.conf On Thu, May 29, 2008 at 11:04 PM, Achilleas Mantzios [EMAIL PROTECTED] wrote: Στις Friday 30 May 2008 07:35:19 ο/η kevin kempter έγραψε: Hi list; I'm trying to get postgres syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1 Here's my postgres setup log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: security.*/var/log/security auth.info;authpriv.info /var/log/auth.log mail.info /var/log/maillog lpr.info /var/log/lpd-errs ftp.info /var/log/xferlog cron.*/var/log/cron *.=debug /var/log/debug.log *.emerg * # uncomment this to log all writes to /dev/console to /var/log/ console.log #console.info /var/log/console.log # uncomment this to enable logging of all log messages to /var/log/ all.log # touch /var/log/all.log and chmod it to mode 600 before it will work #*.* /var/log/all.log # uncomment this to enable logging to a remote loghost named loghost #*.* @loghost # uncomment these if you're running inn # news.crit /var/log/news/news.crit # news.err/var/log/news/news.err # news.notice /var/log/news/news.notice !startslip *.* /var/log/slip.log !ppp *.* /var/log/ppp.log LOCAL0.* /var/log/pgsql change that to local0.*/var/log/pgsql.log (lowercase, also a .log suffix is more standard) make sure the /var/log/pgsql.log file exists (create it with vi), and then change its permissions to smth like -rw--- 1 root wheel 109274 30 Μαϊ 09:00 /var/log/pgsql.log This works in my FreeBSD system, although with 7.4.*, i dont have any 8.3.1 handy at the moment. I dont see any files show up in /var/log what am I doing wrong? Thanks in advance.. /Kevin -- Achilleas Mantzios -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgres, syslog and freeBSD
1) syslog.conf: !postgres *.* /var/log/postgresql.log 2) in your root shell: touch /var/log/postgresql.log 3) don't forget newsyslog.conf 4) don't forget man syslog.conf On Thu, 29 May 2008 22:35:19 -0600 kevin kempter [EMAIL PROTECTED] wrote: Hi list; I'm trying to get postgres syslog to get along with no luck. I'm running freeBSD7 and postgres 8.3.1 Here's my postgres setup log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: security.*/var/log/security auth.info;authpriv.info /var/log/auth.log mail.info /var/log/maillog lpr.info /var/log/lpd-errs ftp.info /var/log/xferlog cron.*/var/log/cron *.=debug /var/log/debug.log *.emerg * # uncomment this to log all writes to /dev/console to /var/log/ console.log #console.info /var/log/console.log # uncomment this to enable logging of all log messages to /var/log/ all.log # touch /var/log/all.log and chmod it to mode 600 before it will work #*.* /var/log/all.log # uncomment this to enable logging to a remote loghost named loghost #*.* @loghost # uncomment these if you're running inn # news.crit /var/log/news/news.crit # news.err/var/log/news/news.err # news.notice /var/log/news/news.notice !startslip *.* /var/log/slip.log !ppp *.* /var/log/ppp.log LOCAL0.* /var/log/pgsql I dont see any files show up in /var/log what am I doing wrong? Thanks in advance.. /Kevin -- Sincerely, Gergely Czuczy Harmless Digital Bt mailto: [EMAIL PROTECTED] Tel: +36-30-9702963 signature.asc Description: PGP signature
[ADMIN] Migration from ASCII to UTF8
I have a database that is in ASCII character encoding. How do I go about migrating it to UTF8? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu My e-mail address has changed to [EMAIL PROTECTED]
[ADMIN] initdb problem - ld.so.1
Hi, I am using Solaris 10 5/08 x86. I have downloaded the 8.3 binary and install in under /usr. When I initdb by su postgres: $ /usr/postgres/8.3-community/bin/64/initdb -D /var/lib/pgsql/data output: ld.so.1: initdb: fatal: libxslt.so.1: open failed: No such file or directory Killed What's going on? How can I solve it? Regards, Terence
Re: [ADMIN] Migration from ASCII to UTF8
ASCII character encoding means that the database does not care about the encoding. So it is the responsibility of the programs you use, to use the correct encoding for your application. So you need to know the used encoding of your applications/data in your database. Then you can convert a text backup by recode, iconv or anything like that to utf8. You should be able to restore the corrected dump into a utf8 database. If your applications used different encodings you have to fix this somehow by hand first. In chapter 22 of the manual you can find more details about encodings. Best regards Ivo Am Freitag, 30. Mai 2008 15:45:25 schrieb Campbell, Lance: I have a database that is in ASCII character encoding. How do I go about migrating it to UTF8? Thanks, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs University of Illinois 217.333.0382 http://webservices.uiuc.edu My e-mail address has changed to [EMAIL PROTECTED] -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] dobc install error on Windows
I'm trying to install 8.3.1 (binaries) on Win2003 using windows installer (msi). I'm runnning silent install with: ADDLOCAL=server,psql,pgadmin,psqlodbc,nls and I'm getting error message saying, that psqlodbc is not included in the package. When I exclude odbc: ADDLOCAL=server,psql,pgadmin,nls install works fine. Is it true that odbc was excluded from 8.3.1 Windows distribution package? Should I change my scripts to run separate odbc install? I didn't have this problem with 8.2: odbc was in cluded along with everything else. Thanks in advance, Igor
[ADMIN] Using psql variables in scripts
Would like to use variables in combination with files for common psql queries, and am using PG 8.1.4. For example \set table_name pg_class select * from pg_tables where tablename = ':table_name'; This returns no rows, even though the customer table exists. It appears to be search for a table called :table_name. I can get this to work by doing the following: \set table_name '\'pg_class\'' select * from pg_tables where tablename = :table_name; schemaname | tablename | tableowner | tablespace | hasindexes | hasrules | hastriggers +---++++ --+- pg_catalog | pg_class | postgres || t | f | f Is there any way to do use variables within quotes? Thanks, Corey Horton
[ADMIN] odbc install error on Windows
I'm trying to install 8.3.1 (binaries) on Win2003 using windows installer (msi). I'm runnning silent install with: ADDLOCAL=server,psql,pgadmin,psqlodbc,nls and I'm getting error message saying, that psqlodbc is not included in the package. When I exclude odbc: ADDLOCAL=server,psql,pgadmin,nls install works fine. Is it true that odbc was excluded from 8.3.1 Windows distribution package? Should I change my scripts to run separate odbc install? I didn't have this problem with 8.2: odbc was in cluded along with everything else. Thanks in advance, Igor
[ADMIN] End of Data test?
Hello, I'm backing up my databases on Monday, Wednesday, and Fridays. I'm writing a script to further automate this process. Is there a way that I can test to make sure that pg_dump has actually backed up the entire system. It seems like there should be a return code or something that will tell me that there has been a normal completion. Thanks, Carol -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgres, syslog and freeBSD
Hello, kevin kempter wrote: log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: LOCAL0.*/var/log/pgsql I dont see any files show up in /var/log what am I doing wrong? According to man-page of syslog.conf the name of facility is local0, but not LOCAL0: The facility describes the part of the system generating the message, and is one of the following keywords: auth, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovskih -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgres, syslog and freeBSD
Hello, kevin kempter wrote: log_destination = 'syslog' #logging_collector = off syslog_facility = 'LOCAL0' syslog_ident = 'postgres' silent_mode = on log_min_duration_statement = 0 Here's my /etc/syslog.conf file: LOCAL0.*/var/log/pgsql I dont see any files show up in /var/log what am I doing wrong? According to man-page of syslog.conf the name of facility is local0, but not LOCAL0: The facility describes the part of the system generating the message, and is one of the following keywords: auth, authpriv, console, cron, daemon, ftp, kern, lpr, mail, mark, news, ntp, security, syslog, user, uucp and local0 through local7. Also it might be that syslog do not create this file, try to create it by self: # touch /var/log/pgsql With regards, Alexander Vysokovskih -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Norton 360 and missing pg_twophase, pg_tblspc
Hi there I've had a serious problem at a client's site where we were called in to check our app based on postgres that wouldn't start. After Norton 360 was installed, the source of the problem was located at the /data directory having two missing sub-directories /pg_twophase /pg_tblspc how could these get removed? is it possible (or likely) for a crashing postmaster to trash these directories? Assuming Norton has come down like an anvil on postgres, would it cause damage to the install like this? Unfortunately, we can't say it definitely was Norton, because we got involved in issues there at the eleventh hour. Any ideas guys? - We have hundreds of users running postgres on windows servers, if they are going to get fragged like this by Norton ,we need to warn them all ASAP. Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin