[ADMIN] Start problem on Linux

2007-07-08 Thread David
I just installed PostgreSQL 8.2.3 on an Ubuntu server 7.04. The server is setup in their server mode -- no gui, command line only. The system works fine -- I can connect with psql using localhost and I have created users and installed a database imported from a Win32 test platform. I have two pr

Re: [ADMIN] Start problem on Linux

2007-07-08 Thread Tom Lane
David <[EMAIL PROTECTED]> writes: > First: When I restart the Ubuntu server, the Postgres instance is > started and listens on port 5432 using ssl as requested. However, it > does not created its postmaster.pid file in the PGDATA directory. The postmaster will certainly not start without creating

Re: [ADMIN] replicating postgresql database to ms-sql database

2007-07-08 Thread Ben Kim
On Fri, Jul 06, 2007 at 10:48:48AM -0700, Mary Anderson wrote: I have been asked if it is possible to asynchronously replicate a postgresql database to ms-sql. My answer is yes, provided postgresql ORM features aren't used in the design of the database. One does an ascii dump of the tables

[ADMIN] Catalog insertion

2007-07-08 Thread Carmen Martinez
Hello, I am trying to include new tables in the PG catalog. Also, I am doing that using the JDBC interface in a Java program. But when I connect to de Postgress template1 database and I execute the CREATE TABLE sentence an error message appears saying: "System catalog modifications are currentl

Re: [ADMIN] Catalog insertion

2007-07-08 Thread Alvaro Herrera
Carmen Martinez escribió: > Hello, > I am trying to include new tables in the PG catalog. Also, I am doing > that using the JDBC interface in a Java program. But when I connect to > de Postgress template1 database and I execute the CREATE TABLE > sentence an error message appears saying: "System c