[PHP] Problem getting PostgreSQL to compile
Hello, I'm running RH 7 and Apache. I have the latest version of PostgreSQL and it is installed and running correctly. I have installed PHP with the --with-pgsql and it seems to install everything needed, but when I try to use pg_connect() it fails to connect. Any ideas what I can do? Thanks, Kevin [EMAIL PROTECTED] _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP] Problem getting PostgreSQL to compile
Yes, I've checked phpinfo() and not it is not compiled in. That is the
problem. I have recompiled PHP with pgsql support and there is some
problem. I'm not sure why it isn't compiling it in. I've tried everything
I knowthe installation goes fine...no error messages, everything seems
ok.
Any ideas?
>From: The Hermit Hacker <[EMAIL PROTECTED]>
>To: K Old <[EMAIL PROTECTED]>
>CC: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
>Subject: Re: [PHP] Problem getting PostgreSQL to compile
>Date: Fri, 2 Mar 2001 22:30:11 -0400 (AST)
>
>
>have you checked phpinfo() to make sure that pgsql support is actually
>compiled in? if so, any errors on connection, or just silently fails?
>
>On Fri, 2 Mar 2001, K Old wrote:
>
> > Hello,
> >
> > I'm running RH 7 and Apache. I have the latest version of PostgreSQL
>and it
> > is installed and running correctly. I have installed PHP with the
> > --with-pgsql and it seems to install everything needed, but when I try
>to
> > use pg_connect() it fails to connect. Any ideas what I can do?
> >
> > Thanks,
> > Kevin
> > [EMAIL PROTECTED]
> > _
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>Marc G. Fournier ICQ#7615664 IRC Nick:
>Scrappy
>Systems Administrator @ hub.org
>primary: [EMAIL PROTECTED] secondary:
>scrappy@{freebsd|postgresql}.org
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Easiest Way to Upgrade PHP
Hello all, Quick question. I'm wondering what the easiest way to upgrade PHP is? For instance, right now I have PHP 3 installed on a RH6.1 box and would like to upgrade to the latest version. Even though it was installed using RPMs can I use the tar.gz and build it to apply the upgrade? And then for each release after that just build it manually (I assume it will overwrite whatever needs to be "upgraded")? Red Hat is very slow about getting RPMs out and I wanted to stay on top of everything. Thanks Kevin _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] PostgreSQL query taking a long time
Hello all,
I have a PostgreSQL database that is storing The Bible. It has 31,103
records in it and I have a PHP page executing this query:
SELECT
books.book_name, bible.chapter, bible.verse, bible.versetext
FROM asv_bible bible, book_bible books WHERE bible.book = books.id ORDER BY
random() LIMIT 1
The database schema is:
/*
Sequences
*/
CREATE SEQUENCE "book_bible_seq" start 1 increment 1 maxvalue 2147483647
minvalue 1 cache 1;
/*
Table structure for table "asv_bible"
*/
CREATE TABLE "asv_bible" (
"id" int8 NOT NULL,
"book" int8,
"chapter" int8,
"verse" int8,
"versetext" text,
CONSTRAINT "asv_bible_pkey" PRIMARY KEY ("id")
);
/*
Table structure for table "book_bible"
*/
CREATE TABLE "book_bible" (
"id" int4 DEFAULT nextval('book_bible_seq'::text) NOT NULL,
"book_name" varchar(20),
CONSTRAINT "book_bible_pkey" PRIMARY KEY ("id")
);
Right now it takes 9 seconds to return the results. I was wondering if
anyone could offer any help with lowering the time it takes to run?
Or if this is the normal runtime for a database of this size, I'd just like
confirmation.
Thanks,
Kevin
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
