Re: [GENERAL] [ADMIN] Unable to reload postgresql.conf without restarting

2013-01-03 Thread sk baji 
 Hi,

 I made some changes to postgresql.conf and I want them to take effect
without
 having to restart the server.

 I tried

 select pg_reload_conf();
 /usr/pgsql-9.1/bin/pg_ctl reload

 but when I do 'show all', I see no changes take effect.

 There settings I tried to change are:
 -effective_cache_size
 -work_mem

 Im using posgres 9.1 on Centos Linux (amazon ec2)

I think, these parameters are duplicated in postgresql.conf file. Can you
check whether the same parameters are exits in bottom of the file. If so,
you need to change at the bottom(or comment them).


Regards,
Baji Shaik.



On Thu, Jan 3, 2013 at 5:17 PM, Bruce Momjian br...@momjian.us wrote:

 On Thu, Jan  3, 2013 at 11:25:41AM -0500, Jose Martinez wrote:
  Hi,
 
  I made some changes to postgresql.conf and I want them to take effect
 without
  having to restart the server.
 
  I tried
 
  select pg_reload_conf();
  /usr/pgsql-9.1/bin/pg_ctl reload
 
  but when I do 'show all', I see no changes take effect.
 
  There settings I tried to change are:
  -effective_cache_size
  -work_mem
 
  Im using posgres 9.1 on Centos Linux (amazon ec2)

 That is quite odd.  Can you show us the commands and the postgresql.conf
 line you are changing?

 --
   Bruce Momjian  br...@momjian.ushttp://momjian.us
   EnterpriseDB http://enterprisedb.com

   + It's impossible for everything to be true. +


 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] How to list all schema names inside a PostgreSQL database through SQL

2012-11-15 Thread sk baji 
If you are looking for list of empty schema's (No objects in schema), then
you can use below query:

select nspname from pg_namespace where oid not in (select relnamespace from
pg_class) and oid not in (select oid from pg_proc);


Regards,
Baji Shaik.

On Thu, Nov 15, 2012 at 6:13 PM, Achilleas Mantzios 
ach...@matrix.gatewaynet.com wrote:

 On Πεμ 15 Ποε 2012 20:31:05 Xiaobo Gu wrote:
  Hi,
 
  How can I list  all schema names inside a PostgreSQL database through
  SQL, especially thoese without any objects created inside it.
 
 

 1st solution :

 select catalog_name,schema_name from information_schema.schemata ;

 2nd solution :

 select * from pg_namespace ;

  Regards,
 
  Xiaobo Gu
 
 
 
 -
 Achilleas Mantzios
 IT DEPT


 --
 Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
 To make changes to your subscription:
 http://www.postgresql.org/mailpref/pgsql-general