Page 1 of 1
DB Port Change: Possible?
Posted: Thu Feb 19, 2009 6:57 pm
by genesis
I have a desire to use an aggregator for Postgres called "pgpool"; this requires that I change the connection port for Seredipity from its standard.
The change is transparent to the application other than the need for a custom port number.
I don't see a port field in the configuration area, however.
Is there a way to specify this, do I need to do it by hand, and if the latter, where would that be in the configuration files?
Thanks in advance!
Re: DB Port Change: Possible?
Posted: Fri Feb 20, 2009 12:31 pm
by garvinhicking
Hi!
Usually you should be able to simply specify something like "localhost:4711" into the hostname, so that you can append the portnumber there.
Regards,
Garvin
Re: DB Port Change: Possible?
Posted: Sat Feb 21, 2009 11:11 pm
by genesis
Nope; in serendipity_config_local.inc.php I have:
$serendipity['dbHost'] = 'genesis.denninger.net:55432';
and what I get back is:
Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not translate host name "genesis.denninger.net:55432" to address: hostname nor servname provided, or not known in /usr/local/apache2/htdocs/market-ticker/include/db/postgres.inc.php on line 64
serendipity error: unable to connect to database - exiting.
Re: DB Port Change: Possible?
Posted: Sat Feb 21, 2009 11:17 pm
by garvinhicking
Hi!
Have you tried the PDO-PostgreSQL layer instead, maybe?
Also, using "genesis.denninger.net port=55432" might work.
(I'm not experience with PSQL, so I only speak with mysql knowledge, sorry)
Regards,
Garvin
Re: DB Port Change: Possible?
Posted: Sun Feb 22, 2009 1:39 am
by genesis
Got it - "genesis.denninger.net port=55432" worked.