Skip site navigation (1) Skip section navigation (2)

Re: Detemine name of replication schema

From: "Melvin Davidson" <mdavidson(at)cctus(dot)com>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>,<pgadmin-support(at)postgresql(dot)org>
Subject: Re: Detemine name of replication schema
Date: 2006-07-10 16:39:46
Message-ID: 2CC69F840555CB43B04195F218CCB57F300E9C@COENGEX01.cctus.com (view raw or flat)
Thread:
Lists: pgadmin-support
Dave,
 
Much obliged for the suggestion.
 
Here is the query to find all slony schemas.  Maybe this will be of help
to others.
 
SELECT  nspname AS "Slony Schema"

  FROM pg_namespace nsp

  JOIN pg_proc pro ON pronamespace=nsp.oid AND proname = 'slonyversion'

 ORDER BY nspname;



________________________________

From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk] 
Sent: Friday, July 07, 2006 10:14 PM
To: Melvin Davidson; pgadmin-support(at)postgresql(dot)org
Subject: RE: [pgadmin-support] Detemine name of replication schema


 


________________________________

	From: pgadmin-support-owner(at)postgresql(dot)org
[mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Melvin
Davidson
	Sent: 07 July 2006 21:12
	To: pgadmin-support(at)postgresql(dot)org
	Subject: [pgadmin-support] Detemine name of replication schema
	
	

	I tried searching the archive for a similar question, but found
none. 

	I am interested in knowing what query can be used to determine
the name of the replication schema(s) installed. 

	Pgadmin is "aware" of the replication schema(s), as they are
listed for each database 
	    eg:  <dbname> 
	                      Casts 
	                      Languages 
	                      Schemas 
	                      Replication 

	 So I am curious as to what function or sql query is used to
obtain that information? 

	IOW, I am looking for a generic way to get the names of all
replication schemas in a cluster. 

The easiest way is to turn on SQL query logging in pgAdmin or the server
and see what ends up in the logfile. I suspect (but am too tired to
check right now) that it looks for schemas who's name starts with _, and
contains one of the slony tables.

Regards, Dave

 

 

In response to

pgadmin-support by date

Next:From: Harald Armin MassaDate: 2006-07-11 07:46:05
Subject: Re: Emergency - postgre is not working
Previous:From: Harald Armin MassaDate: 2006-07-10 15:24:43
Subject: Re: Emergency - postgre is not working

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group