Hi, Unlike the recent Some introductory PostgreSQL pointers (which stops at the second sql statement with a parse error) this guide actually works. http://drupal4hu.com/node/118 Regards, NK
And if anyone knows how to use pgSQL with PHP on Leopard without recompiling PHP from source, please point me to the instructions. Since I upgraded, it's been MySQL only, since 10.5.1 ships with PHP's pgSQL driver not compiled. - Ken Rickard agentrickard On Feb 3, 2008 4:17 PM, Karoly Negyesi <karoly@negyesi.net> wrote:
Hi,
Unlike the recent Some introductory PostgreSQL pointers (which stops at the second sql statement with a parse error) this guide actually works. http://drupal4hu.com/node/118
Regards,
NK
-- -- -------------------------------------------------------------- DON'T MISS EARTH'S LARGEST GATHERING OF DRUPAL PROFESSIONALS! Drupalcon Boston 2008 · March 3-6, 2008 Learn more at http://boston2008.drupalcon.org Affordable sponsorship packages available --------------------------------------------------------------
On Feb 3, 2008, at 1:49 PM, Ken Rickard wrote:
Since I upgraded, it's been MySQL only, since 10.5.1 ships with PHP's pgSQL driver not compiled.
I've never had luck getting both MySQL and pgSQL running on a mac without compiling all of the above from source myself. I wrote this up a long time ago here: http://drupal.org/node/68133 -Derek (dww)
You may want to consider Macports - http://www.macports.org/ While it does compile from source it's a package management system so it'll resolve dependicies, etc. It makes if fairly easy to php compiled with pgsql & mysql support. - Jeff Miccolis jeff@developmentseed.org On Feb 3, 2008, at 5:30 PM, Derek Wright wrote:
On Feb 3, 2008, at 1:49 PM, Ken Rickard wrote:
Since I upgraded, it's been MySQL only, since 10.5.1 ships with PHP's pgSQL driver not compiled.
I've never had luck getting both MySQL and pgSQL running on a mac without compiling all of the above from source myself. I wrote this up a long time ago here:
-Derek (dww)
3 feb 2008 kl. 23.30 skrev Derek Wright:
I've never had luck getting both MySQL and pgSQL running on a mac without compiling all of the above from source myself. I wrote this up a long time ago here:
If you use MAMP (http://www.mamp.info/), which is a convenient bundle of Apache, MySQL and PHP for Mac OS X, you already have Postgres support in PHP. All you need is the Postgres server itself. Here is one that is easy to install, but only on 10.4 it seems: http://www.entropy.ch/software/macosx/postgresql/ /Hannes Lilljequist - zoo33
Every time I look at MacPorts, I end up searching for an alternative. With a little effort, I got the package from Marc Liyanage working on Leopard: http://www.entropy.ch/software/macosx/postgresql/ Using dscl on the command line, I was able to create a system user for PostgreSQL just like the one for MySQL. On Feb 3, 2008, at 4:49 PM, Ken Rickard wrote:
And if anyone knows how to use pgSQL with PHP on Leopard without recompiling PHP from source, please point me to the instructions.
Since I upgraded, it's been MySQL only, since 10.5.1 ships with PHP's pgSQL driver not compiled.
- Ken Rickard agentrickard
On Sun, 3 Feb 2008 16:17:31 -0500 "Karoly Negyesi" <karoly@negyesi.net> wrote:
Hi,
Unlike the recent Some introductory PostgreSQL pointers (which stops at the second sql statement with a parse error) this guide actually works. http://drupal4hu.com/node/118
zless /usr/share/doc/postgresql-8.1/README.Debian.gz But well this helps if you're just one of those Elitist that use Debian. -- Ivan Sergio Borgonovo http://www.webthatworks.it
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 In case of Debian, I have written a mini-HOWTO once before. Hope this may help the other as a Debian-base quick start ;-) http://edin.no-ip.com/html/?q=node/338 And my personal multiple database research footnote may also be useful for Drupal + PostgreSQL tester: http://edin.no-ip.com/html/?q=node/360 Regards Ivan Sergio Borgonovo wrote: | On Sun, 3 Feb 2008 16:17:31 -0500 | "Karoly Negyesi" <karoly@negyesi.net> wrote: | | zless /usr/share/doc/postgresql-8.1/README.Debian.gz | | But well this helps if you're just one of those Elitist that use | Debian. | - -- Edison Wong hswong3i@gmail.com http://edin.no-ip.com/html/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHpncYBPIQaq+ZRd8RAjt2AJ9/pKyvECAmsoAELPwM9pwm4KdAIACcCkoI Sx3e+A9M9qPu5NHjXw9tGyA= =+v1L -----END PGP SIGNATURE-----
I've been able to get both running on 10.4 using the entropy.ch ports, but was not able to install the 10.4 build on 10.5 correctly. I will likely hold out for the stable Liyanage package for 10.5, as he compiles in pgSQL, MySQL, and PDO. - Ken On Feb 3, 2008 9:23 PM, Edison Wong <hswong3i@edin.no-ip.com> wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
In case of Debian, I have written a mini-HOWTO once before. Hope this may help the other as a Debian-base quick start ;-) http://edin.no-ip.com/html/?q=node/338
And my personal multiple database research footnote may also be useful for Drupal + PostgreSQL tester: http://edin.no-ip.com/html/?q=node/360
Regards
Ivan Sergio Borgonovo wrote: | On Sun, 3 Feb 2008 16:17:31 -0500 | "Karoly Negyesi" <karoly@negyesi.net> wrote: | | zless /usr/share/doc/postgresql-8.1/README.Debian.gz | | But well this helps if you're just one of those Elitist that use | Debian. |
- -- Edison Wong hswong3i@gmail.com http://edin.no-ip.com/html/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFHpncYBPIQaq+ZRd8RAjt2AJ9/pKyvECAmsoAELPwM9pwm4KdAIACcCkoI Sx3e+A9M9qPu5NHjXw9tGyA= =+v1L -----END PGP SIGNATURE-----
-- -- -------------------------------------------------------------- DON'T MISS EARTH'S LARGEST GATHERING OF DRUPAL PROFESSIONALS! Drupalcon Boston 2008 · March 3-6, 2008 Learn more at http://boston2008.drupalcon.org Affordable sponsorship packages available --------------------------------------------------------------
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 If you hope to get both PDO, MySQL, PostgreSQL, Oracle within single installation, here is a simple HOWTO for building everything from sketch: http://edin.no-ip.com/html/?q=node/353 Or you may have a look about my book page, since I have done a lot of indeed multiple database support research for Drupal 6.x/7.x: http://edin.no-ip.com/html/?q=book Regards Ken Rickard wrote: | I've been able to get both running on 10.4 using the entropy.ch ports, but was not able to install the 10.4 build on 10.5 correctly. | | I will likely hold out for the stable Liyanage package for 10.5, as he compiles in pgSQL, MySQL, and PDO. - -- Edison Wong hswong3i@gmail.com http://edin.no-ip.com/html/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHppP0BPIQaq+ZRd8RAj6KAKCdMla75yE/jpAPZK7Fttuk+SqM5wCeOFFN pVEfqXIWqIHB9geazcR2xFE= =7c4s -----END PGP SIGNATURE-----
On Mon, 4 Feb 2008 00:29:49 +0100 Ivan Sergio Borgonovo <mail@webthatworks.it> wrote:
On Sun, 3 Feb 2008 16:17:31 -0500 "Karoly Negyesi" <karoly@negyesi.net> wrote:
Hi,
Unlike the recent Some introductory PostgreSQL pointers (which stops at the second sql statement with a parse error) this guide actually works. http://drupal4hu.com/node/118
zless /usr/share/doc/postgresql-8.1/README.Debian.gz
There is also a nice GUI tool (pgadmin3) that look similar to MS SQL Query Analyser that let you edit pg_hba.conf (and a lot more things) I never tried the "config" functionality. Generally pg_hba.conf comes with clear examples and you can find it in a sane place /etc/postgresql/... and it is just a matter of copying and pasting the examples. The only "hard" information to get is you've to look for pg_hba.conf. Typing "postgres authentication" or "postgres authorisation" google point you to the right pages but none of them use the <blink> tag. There are tens of reasonable configurations for pg_hba.conf depending on needed flexibility, paranoia level, development habits... Whatever I may suggest may make unhappy someone. The examples in pg_hba.conf are pretty straight forward, just pick your choice. 4 years ago my expectations on Debian drupal package drove me astray and someone pointed me to Debian package postgresql-doc /usr/share/doc/postgresql-doc/README.Debian.gz where you could find some very synthetic guideline too... but I'm not expecting people install documentation. I didn't. Summarizing it up: - edit pg_hba.conf - use createuser and createdb commands from postgres user (su - postgres) -- Ivan Sergio Borgonovo http://www.webthatworks.it
participants (8)
-
Darren Oh -
Derek Wright -
Edison Wong -
Hannes Lilljequist -
Ivan Sergio Borgonovo -
Jeff Miccolis -
Karoly Negyesi -
Ken Rickard