On Wed, Feb 27, 2019 at 12:59 PM Julie Nishimura <juliez...@hotmail.com> wrote:
> Hello Steve, > Thanks a lot for your info yesterday, it was very useful. If I run this > command on some of the servers and the results look like this, what would > it tell you? > > select * from pg_extension ; > extname | extowner | extnamespace | extrelocatable | extversion | > extconfig | extcondition > > --------------+----------+--------------+----------------+------------+-----------+-------------- > plpgsql | 10 | 11 | f | 1.0 > | | > postgres_fdw | 10 | 2200 | t | 1.0 > | | > > > postgres=# select * from pg_extension ; > extname | extowner | extnamespace | extrelocatable | extversion | > extconfig | extcondition > > ---------+----------+--------------+----------------+------------+-----------+-------------- > plpgsql | 10 | 11 | f | 1.0 > | | > (1 row) > > I understood it is slony, the rest I need to find from hba file? > > > I am not experienced with Slony - others on this list will be better able to help there. Somehow I was thinking it created an extension but I don't think that's the case. You may find some info in the monitoring section of the slony docs (http://www.slony.info/documentation/1.2/monitoring.html), in particular looking for the existence of sl_* tables/views. The postgres_fdw is the Foreign Data Wrapper extension ( https://www.postgresql.org/docs/current/postgres-fdw.html) and plpgsql is the PL/pgSQL procedural language ( https://www.postgresql.org/docs/current/plpgsql.html). (Be sure to reply-all so others on the list can help and future viewers can find solutions.) Cheers, Steve
