Radicore Forum: How To » Multi servers and PostgreSQL

Home » RADICORE » How To » Multi servers and PostgreSQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Multi servers and PostgreSQL [message #7251]

Wed, 06 February 2019 12:46

pdv
Messages: 15
Registered: January 2019

Junior Member

Hi,

I'm trying to access some existing PostgreSQL databases on macos with Radicore.

Since I want to keep my existing (pgsql)databases unmodified, Radicore is loaded in a separate (pgsql)database and I must use several connections. In my case these are all hosted by localhost and this poses a problem.

The function &_getDBMSengineByHost ($dbhost) in dict_databse_s01.class.inc loops over servers until a matching host is found and then breaks the loop, so that of e.g. 2 different (pgsql) servers on localhost, only one can be reached.

I solved this by passing the server(number) instead of the host: function &_getDBMSengineByServer ($server) and then no looping is needed since $server can directly be used as an index in the $servers array.

Regards,

Patrick

Report message to a moderator

[Message index]

		Multi servers and PostgreSQL By: pdv on Wed, 06 February 2019 12:46
		Re: Multi servers and PostgreSQL By: AJM on Thu, 07 February 2019 05:02
		Re: Multi servers and PostgreSQL By: pdv on Thu, 07 February 2019 07:46
		Re: Multi servers and PostgreSQL By: AJM on Fri, 08 February 2019 05:08
		Re: Multi servers and PostgreSQL By: pdv on Sat, 09 February 2019 14:17
		Re: Multi servers and PostgreSQL By: AJM on Mon, 11 February 2019 04:45

Previous Topic:	$lock_str FOR UPDATE FOR $tablename with PostgreSQL
Next Topic:	convert_parent_id_to_child_id

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Dec 22 00:08:33 EST 2024

Total time taken to generate the page: 0.00977 seconds