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!
DB Port Change: Possible?
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: DB Port Change: Possible?
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: DB Port Change: Possible?
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.
$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.
-
garvinhicking
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: DB Port Change: Possible?
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Re: DB Port Change: Possible?
Got it - "genesis.denninger.net port=55432" worked.