Re: [ADMIN] archive_command

2009-09-01 Thread Abbas
On Tue, Sep 1, 2009 at 4:47 PM, samana srikanth wrote: > can i change the "archive_command" from the postgres sql prompt ot sql > command? > Thanks > Srikanth > Nope, You can't change archive_command from psql prompt. Abbas

Re: [ADMIN] Problem with PostgreSQL 8.2 on Linux Redhat

2007-06-20 Thread Sibte Abbas
't have problem with firewall. Do you have any idea what is the problem? Thanks. Ira Since you are not using the default port, have you configured pgAdmin's port to 5433? -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Logging autovacuum activity

2007-06-20 Thread Sibte Abbas
But I can't find it in the 8.2.4. I could see some developers discussions about making changes to logging autovacuum activity, however could not track the discussion tight enough to find what the final solution is. Thanks Ireneusz Pluta ps -ef | grep autovacuum. -- Sibte Ab

Re: [ADMIN] how to get a list of members of a postgres group?

2007-07-05 Thread Sibte Abbas
an array of the sysid's of all its members. regards, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [ADMIN] row level locking

2007-07-20 Thread Sibte Abbas
r mode. This would eradicate all the Interprocess communication overheads. Accesses this table. I know there are ways to specify locking levels in other DBMSs. To page or table levels. Postgresql handles page level locks implicitly, users do not have any control over them. regards, -- Sibte

Re: [ADMIN] deinstallation - reinstallation on Mac OS 10.4

2007-07-20 Thread Sibte Abbas
a different prefix. For example: ./configure --prefix=/usr/local/pgsql-tmp This will avoid conflicts with old left over files (if any). regards, -- Sibte Abbas EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help sup

[ADMIN] Syncronizing Databases at different Remote Location

2009-11-04 Thread ABBAS SHAKEEL
all A,B,C servers to central server Z. Please suggest how to move forward.(Open source solutions ) -- Best Regards Shakeel Abbas

Re: [ADMIN] Syncronizing Databases at different Remote Location

2009-11-04 Thread ABBAS SHAKEEL
Thanks Sandeep I will have a look to it and will inform you about success or failure. On Wed, Nov 4, 2009 at 4:03 PM, sandeep kumar wrote: > Shakeel, this can be done using symmetricDS. > > cheers > //Sandeep > > > > > --- On Wed, 4/11/09, ABBAS SHAKEEL wrote

Re: [ADMIN] Syncronizing Databases at different Remote Location

2009-11-04 Thread ABBAS SHAKEEL
t > updates, conflicts and is even optimized. > > Since i worked on this problem for quite some time and didnt find any > direct solution, i guess there isn't much else to do here. > > Cheers, > Shruthi > > > > On Wed, Nov 4, 2009 at 3:48 PM, ABBAS SHAKEEL > wro

[ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
in JAVA. but its seems to be a different scene. Can some one Please compare inheritence in JAVA and Postgresql OR make me clear about for what inheritance is introduced in Postgres. -- Best Regards Shakeel Abbas

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
iefly compare concept of inheritance in Postgres and JAVA, as my mind is trying to compare this with already stored concept in mind about inheritance ;) On Wed, Dec 16, 2009 at 11:51 AM, Scott Marlowe wrote: > On Tue, Dec 15, 2009 at 11:36 PM, ABBAS SHAKEEL > wrote: > > Hello >

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-15 Thread ABBAS SHAKEEL
as well which describe the advantage of inheritance in Postgres in detail . Example can be found here<http://knol.google.com/k/postgresql-inheritance#> . On Wed, Dec 16, 2009 at 12:15 PM, Scott Marlowe wrote: > On Wed, Dec 16, 2009 at 12:01 AM, ABBAS SHAKEEL > wrote: > > Thanks

Re: [ADMIN] Inheritance in Postgresql ?

2009-12-16 Thread ABBAS SHAKEEL
Thanks Richard Broersma for the presentation. Its really nice and explains advantages and disadvantages in a nice way. On Wed, Dec 16, 2009 at 8:13 PM, Richard Broersma < richard.broer...@gmail.com> wrote: > On Tue, Dec 15, 2009 at 11:33 PM, ABBAS SHAKEEL > wrote: > > > I

Re: [ADMIN] Problems to connect to a postgreSQL 8.4 database on windows 2003 server

2009-12-18 Thread ABBAS SHAKEEL
Sèneca > > > > > ---Procureu enviar els correus massius amb les direccions en còpia carbó > oculta (cco) per no col·laborar amb qui les col·lecciona per enviar SPAM--- > -- Best Regards Shakeel Abbas

[ADMIN] inet Operator Does not exists

2010-05-08 Thread ABBAS SHAKEEL
.1. I was wondering if there is some thing wrong from my side. Below is the error message ERROR: operator does not exist: inet - inet HINT: No operator matches the given name and argument type(s). You may need to add explicit type casts. CONTEXT: SQL function "inet_to_bigint" -- Best Regards Shakeel Abbas