RE: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database).

2001-05-20 Thread Willis, Ian (Ento, Canberra)
Oracle financials has about 2000 tables in a single database :> but of course that must not be designed using structured design techniques. -- Ian Willis -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: Saturday, 19 May 2001 12:45 AM To: Trygve Falch Cc: [EMAIL PROTECTE

[GENERAL] Compiling for Caldera on 2nd Drive

2001-05-20 Thread R Talbot
Tom I have downloaded postgres V. 7.1.1 and run gunzip and tar on the file before I run config I need direction.. I noticed less space on /dev/sda3 then on /dev/sdb/2.. So, I have decided on an install on /dev/sdb2 which I mount on boot through mtab to /mnt/sdb2 It looks like... Filesystem

Re: [GENERAL] debian packages for Postgresql 7.1 or higher ?

2001-05-20 Thread Oliver Elphick
larry a price wrote: >it's in testing, just add a line to to your apt-sources file, don't forget >to comment it out after you add the db and before run apt-get upgrade tho > > >Larry Price | "We have seen the truth. >[EMAIL PROTECTED] | And the truth makes no sense." -chestert

Re: [GENERAL] Why can't I do this (setup question)

2001-05-20 Thread Paul Tomblin
Quoting Tom Lane ([EMAIL PROTECTED]): > Paul Tomblin <[EMAIL PROTECTED]> writes: > > Is there a postmaster log other than what's in /var/log/messages? > > Yes, the postmaster's stderr output. What is your startup script doing > with that? I'm using the one that comes with the 7.1 RPM, (from Lam

Re: [GENERAL] Why can't I do this (setup question)

2001-05-20 Thread Tom Lane
Paul Tomblin <[EMAIL PROTECTED]> writes: > Is there a postmaster log other than what's in /var/log/messages? Yes, the postmaster's stderr output. What is your startup script doing with that? regards, tom lane ---(end of broadcast)

Re: [GENERAL] Why can't I do this (setup question)

2001-05-20 Thread Paul Tomblin
Quoting Tom Lane ([EMAIL PROTECTED]): > Paul Tomblin <[EMAIL PROTECTED]> writes: > > I've got PostgreSQL 7.1 installed from rpms on a RedHat 6.2 system. I > > want the data directory on a separate partition, so I shut down, tar the > > whole directory into the other directory, mount it, and when