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 по дате отправления:

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Optimizing Database High CPU
Следующее
От: Scottix
Дата:
Сообщение: Re: Optimizing Database High CPU