Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE » How To » Multi servers and PostgreSQL
Multi servers and PostgreSQL [message #7251] Wed, 06 February 2019 12:46 Go to previous message
pdv is currently offline  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
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: $lock_str FOR UPDATE FOR $tablename with PostgreSQL
Next Topic: convert_parent_id_to_child_id
Goto Forum:
  


Current Time: Fri Mar 29 10:27:39 EDT 2024

Total time taken to generate the page: 0.00894 seconds