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

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

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

[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

[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,pgad

[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

[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,pgadmi

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

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

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

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