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
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
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
>
> 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
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
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
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
"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
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
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
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
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
12 matches
Mail list logo
