[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
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] 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
[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] 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] 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
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] 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
[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]
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
