RE: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database).
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 PROTECTED] Subject: Re: [GENERAL] Queries across multiple databases (was: SELECT from a table in another database). "Trygve Falch" <[EMAIL PROTECTED]> writes: > And putting 200+ tables in one single database is not an option. Why not? regards, tom lane ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
[GENERAL] Compiling for Caldera on 2nd Drive
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 1k-blocks Used Available Use% Mounted on /dev/sda3 2974519 2418544402155 86% / /dev/sdb2 979482239885688993 26% /mnt/sdb2 So my ./configure line will appear as... @$ ./configure --prefix=/mnt/sdb2 --with-perl --with-python --with-tcl --enable-odbc --with-java Does the above look correct ?? Following Questons from Install Man.. To utilize shared libraries I assume I will have to do nothing more per 1.6.1. Shared Libraries "as the sections states unecessary for Linux." ** TRUE or FALSE Further 1.6.2. Environment Variables Per this section set a path for all users in /etc/profile, in my case PATH=$PATH:/mnt/sdb2/usr/local/pgsql/bin:/All/Other/Dirs and MANPATH=$MANPATH:/mnt/sdb2/usr/local/pgsql/man ** TRUE or FALSE DID I Miss anything ... Nothing is worst than an install that doesn't run.. Well almost anything.. ; > ) Thank You Bob T " Swithching from DB2 (0 (0 are They watching !" [] UUU "" UUU ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] debian packages for Postgresql 7.1 or higher ?
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." -chesterton >___ > >On Wed, 16 May 2001, Alex wrote: > >> Are there any debian packages for Postgresql 7.1 or higher for Potato? >> I've tried to get the src-deb from unstable (7.1.1) but it won't compile >> under potato, not unless I upgrade the perl packages as well, which is not >> my idea. It's probably not a good idea to use packages from unstable if you want to keep the rest of your system stable. The unstable packages will certainly pull in a lot of other unstable packages through dependencies, including some major ones like libc6. potato packages are at http://people.debian.org/~elphick/postgresql/potato.html though they are not as up-to-date as the unstable distribution; I do them when I have time. -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "For all that is in the world, the lust of the flesh, and the lust of the eyes, and the pride of life, is not of the Father, but is of the world." I John 2:17 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [GENERAL] Why can't I do this (setup question)
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 Lamar Owen) which redirects stderr to /dev/null. su -l postgres -c "LC_ALL=C /usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster start >/dev/null 2>&1" < /dev/null I guess I should stop that from happening and see what messages come out. I'll report back. -- Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody In 1665 Issac Newton became discouraged when he fell up a flight of stairs. ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Why can't I do this (setup question)
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)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [GENERAL] Why can't I do this (setup question)
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 I start up > > postgresSQL it says it's up, but I can't connect to any databases using > > psql. > > psql: connectDBStart() -- connect() failed: Connection refused > > Is the postmaster running locally > > and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'? > > There is a postmaster running, but no socket in /tmp/ > > Odd. Seems unlikely that that has anything to do with your having moved > the data directory. Any interesting messages in the postmaster log? > Can you connect via TCP? Is there a postmaster log other than what's in /var/log/messages? Because there is nothing useful in there other than a message that it started successfully. -- Paul Tomblin <[EMAIL PROTECTED]>, not speaking for anybody "All life is transitory. A dream. We all come together in the same place at the end of time. If I don't see you again here, I will see you in a little while in the place where no shadows fall." - Delenn ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]