Re: replication topography
От | Steve Crawford |
---|---|
Тема | Re: replication topography |
Дата | |
Msg-id | CAEfWYyzYCZ9fhR869Nf2QELhV8bWfO_zY0k7WWPj9W17r6+0Zg@mail.gmail.com обсуждение исходный текст |
Ответ на | replication topography (Julie Nishimura <juliezain@hotmail.com>) |
Список | pgsql-general |
On Wed, Feb 27, 2019 at 12:59 PM Julie Nishimura <juliezain@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
В списке pgsql-general по дате отправления: