[GENERAL] Determine unused / not referenced large Objects

Hello list, we have a database with several tables containing blobs (as oid), that reference large objects in pg_largeobject. It is my understanding, that the large objects will not be deleted if a row containing the oid is deleted - you have to do that yourself in application logic. (please co

Re: [GENERAL] Determine unused / not referenced large Objects

Tobias Meyer, 28.11.2012 10:02: Hello list, we have a database with several tables containing blobs (as oid), that reference large objects in pg_largeobject. It is my understanding, that the large objects will not be deleted if a row containing the oid is deleted – you have to do that yourself

Re: [GENERAL] Determine unused / not referenced large Objects

> >Isn't vacuumlo supposed to do this kind of cleanup? > >http://www.postgresql.org/docs/current/static/vacuumlo.html > >Regards >Thomas Thank you - I wasn't aware of that utility program - just what I was looking for. Tobias -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

[GENERAL] Database level Replication

Hi , Am running near about 10 databases on one cluster , out of this i want to replicate one database to another server where allready some databases are running , is any tool is der in postgres which can replicate only one database at a time. -- --Regards Ranjeet R. Dhumal

Re: [GENERAL] Database level Replication

Hi, Slony will do that. Have a look here, any way: http://www.postgresql.org/docs/9.2/static/different-replication-solutions.html Cheers Bèrto On 28 November 2012 14:52, Ranjeet Dhumal wrote: > Hi , > > Am running near about 10 databases on one cluster , out of this i want to > replicate one d

Re: [GENERAL] pg_listening_channels()

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Igor Neyman asked: [Postgres 9.2] > How (if it's even possible) can I get listening channels > for all sessions/ connections in the database? No, this is not possible. You can only see items from your own session. - -- Greg Sabino Mullane

[GENERAL] GRANT .. VIEW .. documentation

Hallo, is there a reason why the grant syntax for views isn't included in the documentation? (eg REFERENCES doesnt make sense for a view) cf http://www.postgresql.org/docs/9.2/static/sql-grant.html or \h grant in psql GRANT INSERT ON view_x TO user_y; works this for scripting reasons i suppose (

[GENERAL] Getting show results into a table

Is there a way in sql to get the results of the show all command into a table? I'm expecting something like Insert into Config_history as select * from (show all); Doug Little Sr. Data Warehouse Architect | Business Intelligence Architecture | Orbitz Worldwide 500 W. Madison, Suite 1000 Chi

Re: [GENERAL] Getting show results into a table

Little, Douglas wrote: > Is there a way in sql to get the results of the show all command into a table? > > I'm expecting something like > Insert into Config_history as select * from (show all); insert into Config_history  select name, setting, short_desc from pg_settings; or maybe: create ta

[GENERAL] 'alternatives'

In a query plan, I noticed the following: Join Filter: (((all_permissions.role_recursive AND (alternatives: SubPlan 5 or hashed SubPlan 6)) OR (permitted_e.id = deployed_e.id)) AND (NOT (SubPlan 13))) What's the 'alternatives' line? Brand new to me! -- -- Christophe Pettus x...@th

Re: [GENERAL] Getting show results into a table

On Wed, 2012-11-28 at 12:38 -0600, Little, Douglas wrote: > Is there a way in sql to get the results of the show all command into a table? > SELECT name, setting, short_desc FROM pg_settings > I'm expecting something like > Insert into Config_history as select * from (show all); > INSERT INTO

Re: [GENERAL] Getting show results into a table

Thanks everybody.Always wondered where the command was sourcing the data. Thanks -Original Message- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Wednesday, November 28, 2012 3:24 PM To: Little, Douglas Cc: PostgreSQL General (pgsql-general@postgresql.org) Subject: Re

Re: [GENERAL] 'alternatives'

Hi Christophe, On 2012-11-28 13:07:12 -0800, Christophe Pettus wrote: > In a query plan, I noticed the following: > > Join Filter: (((all_permissions.role_recursive AND > (alternatives: SubPlan 5 or hashed SubPlan 6)) OR > (permitted_e.id = deployed_e.id)) AND (NOT (Sub

Re: [GENERAL] 'alternatives'

Hi, Andres, Thanks! On Nov 28, 2012, at 1:58 PM, Andres Freund wrote: > http://www.postgresql.org/docs/current/interactive/release-9-2.html#AEN110503 Does that apply to views as well? (This particular plan was not from a prepared or PL/pgSQL statement, but did include views.) -- -- Christoph

[GENERAL] pgagent linux install issues

Hi, I'm attempting to install pgagent on SLES 11. So far I have downloaded the pgagent (3.3.0) to the server. Extracted using gunzip and untarred. I had the sysadmin install cmake 2.6 & wxGTK & wxGTK-devel using yast. When i run wx-config it shows version 2.8.10 When i attempt to install pgagent I

Re: [GENERAL] pg_listening_channels()

From: Greg Sabino Mullane [g...@turnstep.com] Sent: Wednesday, November 28, 2012 10:26 AM To: pgsql-general@postgresql.org Subject: Re: pg_listening_channels() -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Igor Neyman asked: [Postgres 9.2] > How (i

Re: [GENERAL] 'alternatives'

Hi, On 2012-11-28 14:16:18 -0800, Christophe Pettus wrote: > Thanks! Not much to thank for, the answer was actually wrong... > Does that apply to views as well? (This particular plan was not from a > prepared or PL/pgSQL statement, but did include views.) Its not really relevant for views no.

[GENERAL] Updateable VIEWS and the manual

Hi, I just noticed the following statement in the CREATE VIEW documentation (9.2 and 9.1): Currently, views are read only: the system will not allow an insert, update, or delete on a view. You can get the effect of an updatable view by creating rules that rewrite inserts, etc. on th

Re: [GENERAL] 'alternatives'

Andres Freund writes: > The commit introducing this is: > http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=bd3daddaf232d95b0c9ba6f99b0170a0147dd8af > What that does to add hashing support for IN(). But hashing can be > pessimal in comparison to a explicit check if only a few value

Re: [GENERAL] pg_listening_channels()

Igor Neyman writes: > With PG 9.0 changes I lost ability to check if anyone is interested in the > NOTIFY signal and payload I'm about to send. > Seems like this change was not thought through completely. [ shrug... ] It was debated extensively and the advantages of the new implementation were d

Re: [GENERAL] create table in memory

Thanks Merlin, I'll take a better look at CTE. Best regards Seref On Tue, Nov 27, 2012 at 4:48 PM, Merlin Moncure wrote: > On Tue, Nov 27, 2012 at 10:06 AM, Seref Arikan > wrote: > > I have a function that creates a temp table, inserts rows into it, > performs > > joins, and returns a single

Re: [GENERAL] Updateable VIEWS and the manual

On Wed, Nov 28, 2012 at 4:43 PM, Thomas Kellerer wrote: > Hi, > > I just noticed the following statement in the CREATE VIEW documentation (9.2 > and 9.1): > > Currently, views are read only: the system will not allow an insert, > update, or delete on a view. You can get the effect of an up

[GENERAL] Chang wal block size and database block size in Windows

Hi everyone , I work with PostgreSQL on Windows XP . I want to ask you something .How can i change Postgres wal block size and database block size in Windows ?.I had tried search in postgresql.conf but seem these params not list in this file , i think it would be place at somewhere -- View this

Re: [GENERAL] Chang wal block size and database block size in Windows

classical_89 writes: > Hi everyone , I work with PostgreSQL on Windows XP . I want to ask you > something .How can i change Postgres wal block size and database block size > in Windows ? You'd need to recompile from source, and tell the configure script which block size you want. (It looks like

[GENERAL] Is there a working pgsql-fdw for PostgreSQL 9.2?

Only found one http://interdbconnect.sourceforge.net/pgsql_fdw/pgsql_fdw-en.html working for PostgreSQL 9.1.