[GENERAL] Problem: Failed Make on Linux Pgres v. 7.1.2

Help.. I had been running my compiled source v. 7.0.3 this compiled and runs fine.. First is there a great need to move to v. 7.1.2? What advantages are offred? I had one success and two failures on Make . DUe to either the libc difference or GNU Make difference If I am right is it worth the

[GENERAL] Hardware tuning (Was: Performance question)

On Fri, 21 Sep 2001, Justin Clift wrote: > Hi Andreas, > > I'm running PostgreSQL 7.1.3 here on a PC with nearly a gig of ram, and > running Linux Mandrake 8.0 > > First thing I did was to increase the amount of shared memory and stuff > which Linux allows things to use : > > echo "kernel.shmall

Re: [GENERAL] [HACKERS] psql and security

"Colin 't Hart" <[EMAIL PROTECTED]> writes: > Does postgres have a concept of a 'root' user? Then the password should > only be prompted when one isn't root; ie. adopt Unix semantics. Can't really do that in psql's \c, since it's establishing a whole new connection; there is no possibility for su

[GENERAL] Recursive queries

I have a database with the following fields: product_id INTEGER parent_id INTEGER nameVARCHAR(64) The idea is that it will store a tree of products and its subproducts. Any row whose parent_id is NULL will be assumed to be a root product (i.e. top level). This means

Re: [GENERAL] Postgres 7.1.3 on OpenBSD 2.9?

It looks like there is something amiss with your installed readline libraries. Are they GNU readline? If not, you may need to install the GNU version. I don't recall of PG expects it precisely, and I cant say if installing GNU will break other programs. Keary Suska Esoteritech, Inc. "Leveraging O

[GENERAL] connection fails

Hello, I\'m trying to connect using an extremely simple php script: $conn = pg_Connect(\"host=localhost dbname=db name user=postgres password=postgres\"); if ($conn) { echo \"ok\"; } else { echo \"failed\"; } I get this error message: Warning: Unable to connect to PostgreSQL server: connectDB

Re: [GENERAL] connection fails

I'm not a PHP-er, but I notice that a difference between the script that works & the one that doesn't is the "host=... portion. Could it be that phpPgAdmin & the script that works do *not* use tcpip to connect & while the failing script does? If so, the message you got also contains the answer- y

[GENERAL] Does postgresql use /tmp?

I'm wondering how much space to allocate to my /tmp partition. Are the sort files still placed in the database directory? e.g. /var/pgsql/data/base/123144/ Does postgresql use much space on /tmp? Thanks, Link. ---(end of broadcast)--- TIP 3: i

Re: [GENERAL] [HACKERS] psql and security

Tatsuo Ishii: > As you can see, psql reconnect as any user if the password is same as > foo. Of course this is due to the careless password setting, but I > think it's better to prompt ANY TIME the user tries to switch to > another user. Comments? Does postgres have a concept of a 'root' user? T

Re: [GENERAL] Problem: Failed Make on Linux Pgres v. 7.1.2

R Talbot <[EMAIL PROTECTED]> writes: > First is there a great need to move to v. 7.1.2? > What advantages are offred? 7.1.x has a lot of enhancements, including outer joins, write-ahead logging (WAL) for better performance, enhancements to PL/pgSQL and much more. > Below are my results ... PLea

[GENERAL] Postgres 7.1.3 on OpenBSD 2.9?

Has anyone out there succeeded in installing Postgres 7.1.3 on an x86-based OpenBSD 2.9 install? My setup - x86 OpenBSD 2.9, out-of-the-box (no patches). Unpacked the Postgres 7.1.3 tarball. Configure, make, make check all pass. Installed cleanly. Updated /var/run/ld.so.hints to include /u

Re: [GENERAL] Postgres 7.1.3 on OpenBSD 2.9?

> > Has anyone out there succeeded in installing Postgres 7.1.3 on an > x86-based OpenBSD 2.9 install? Did ya try the ports tree? 7.1.3 is in it if you are tracking 2.9-current. Else, let me know and I can make the the tarball available for 2.9-release. - Brandon