[ADMIN] Information about psqlODBC parameters

2004-09-01 Thread Richard Harris
Hi, I'm running PostgreSQL 7.4.2, UnixODBC Driver Manager: 03.51.0002.0224 and psqlODBC 7.3.2 on a Red Hat Linux system. I need to understand what the parameters in the odbc.ini do. In particular what these parameters do. Trace TraceFile Debug DebugFile CommLog I looked in the 'Notes on the vari

Re: [ADMIN] Execute pg_dump using psql

2004-08-13 Thread Richard Harris
the file with no error. Sorry for the false alarm. Thanks, Rich -Original Message- From: Richard Harris Sent: Thursday, August 12, 2004 12:25 PM To: '[EMAIL PROTECTED]' Subject: Execute pg_dump using psql Hi, I'm trying to use the psql application to execute pg_dump to b

[ADMIN] Pg_dump does not include database search path in backup file

2004-08-13 Thread Richard Harris
Hi, I'm using PostgreSQL 7.4.2. I have a database with several user defined schemas, e.g., public, shr, sys, acc, prt. I have altered the database search path to include all of the schema. ALTER DATABASE adp_test_db SET search_path to public, shr, sys, acc, prt, svc, fi; I used pg_dump to backup

[ADMIN] Execute pg_dump using psql

2004-08-12 Thread Richard Harris
Hi, I'm trying to use the psql application to execute pg_dump to backup a database named test_db. When I run psql interactively, as user dba connected to database test_db, and enter the command \! pg_dump -U dba -f /backup/adp_test_db.bak -F c test_db The command executes with no error and the

[ADMIN] Database consistency checker

2004-03-29 Thread Richard Harris
Title: Database consistency checker Hi, Does PosgreSQL has a capability to check the internal consistency of tables and and indexes, i.e., a tool like the DBCC capability in MS SQL Server? If so, where is it documented? Thanks, Rich Harris