[ADMIN] kerberos issue with pgadmin3 in windows

Hi guys, I have a Kerberos problem connecting from windows XP SP3 to a postgresql 8.1.18 database running on rhel 5.5. Pgadmin3 says Error connecting to the server: pg_krb5_init: krb5_cc_get_principal: No credential cache found I have the variable PGKRBSRVNAME set to POSTGRES (same value is set

Re: [ADMIN] Transaction ID's and Vacuum

Samuel Stearns writes: > I've got an old 7.4.5 instance of Postgres running on Linux. My transaction > ID's are just over the 1 billion mark. I ran an instance wide vacuum analyse > but this had now effect on the transaction ID count. Do I need to run a > vacuum full? No. There is no need

[ADMIN] Transaction ID's and Vacuum

Howdy, I've got an old 7.4.5 instance of Postgres running on Linux. My transaction ID's are just over the 1 billion mark. I ran an instance wide vacuum analyse but this had now effect on the transaction ID count. Do I need to run a vacuum full? Thanks, Sam

Re: [ADMIN] PG HA solution using DBRD

Thanks for reply. DBRD cfg we have :primary/primary both of the servers can be used for writes/active while only one will be active always and other one is passive ( PG is offline) the user data directories and pg_xlog is using DBRD, the PG software directory and $PG_DATA is local on each

[ADMIN] auto vacuum

Hi All - We run both postgres 8.2.3 and 8.4.1 in unix environment. We have auto vacuum configured and I am trying to find out its effectiveness. Here are a couple of questions: 1) I'm running a query that compares actual table count with the pg_stat table count ( pg_stat_user_tables.n_live_

Re: [ADMIN] PostgreSQL Windows 8.4 tablespaces on remote servers

Lou, Thank you for your comments. The only way I could create a tablespace on a remote server was to use an iscsi. Mapped drives would not work and shared folders (privileges set for postgres server machine, postgres superuser, and owner of tablespace is postgres) also do not work. There may be

Re: [ADMIN] reindex script

Silvio Brandani wrote: > Kevin Grittner ha scritto: >> Check out the CONCURRENTLY keyword in CREATE INDEX: > we really need to migrate to version postges 9.x . FWIW, that's been a feature since 8.2. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes

Re: [ADMIN] reindex script

Kevin Grittner ha scritto: Silvio Brandani wrote: Is it possible to use a reindex in a share lock mode ?? Check out the CONCURRENTLY keyword in CREATE INDEX: http://www.postgresql.org/docs/current/interactive/sql-createindex.html You could create a duplicate index concurrently,

Re: [ADMIN] PostgreSQL Select command that will list only duplicate rows

select rowName,count(1) from table group by rowName having count(1)>1 On Wed, Nov 10, 2010 at 9:06 AM, Khangelani Gama < khangelani.g...@ucs-software.co.za> wrote: > Hi all > > > > I am looking for a PostgreSQL Select command that will list me only > duplicate rows. > > > > I am using psql 8.4.4

[ADMIN] reindex script

we are using reindex on single defragmented indexes on a nigtly schedule script. last night we encounter a problem of lock , a idle in transaction connection keep a lock on the table and the reindex was in a wating status and other connections were in a BIND waiting. Is it possible to use a

Re: [ADMIN] reindex script

Silvio Brandani wrote: > Is it possible to use a reindex in a share lock mode ?? Check out the CONCURRENTLY keyword in CREATE INDEX: http://www.postgresql.org/docs/current/interactive/sql-createindex.html You could create a duplicate index concurrently, drop the old index, and rename the n

[ADMIN] PostgreSQL Select command that will list only duplicate rows

Hi all I am looking for a PostgreSQL Select command that will list me only duplicate rows. I am using psql 8.4.4.10 Thanks in advance Confidentiality Notice:http://ucs.co.za/conf.html The contents of and attachments to this e-mail are intended for the