Re: [ADMIN] PG_UPGRADE major issue

thank you very much On Thu, Jun 20, 2013 at 11:01 AM, Burgholzer, Robert (DEQ) < robert.burghol...@deq.virginia.gov> wrote: > Marcos, > This answer might be best put over on the postGIS listserv, but I will > suggest a couple of strategies based on some differing assumptions and > certainties. >

Re: [ADMIN] PG_UPGRADE major issue

Marcos, This answer might be best put over on the postGIS listserv, but I will suggest a couple of strategies based on some differing assumptions and certainties. One certainty - it seems that you absolutely have to have some form of PostGIS installed in order to perform the postgreSQL upgrade u

Re: [ADMIN] PG_UPGRADE major issue

thanks for your reply, yes i did not have any postgis installation. i'm a little bit confused right and i really need some help.. this is my case: i have pg8.3.2 running with postgis 1.3.x, i'm willing to upgrade to pg9.2.4 using the pg_upgrade utility, now the problem is that apparently i need to

Re: [ADMIN] excessive WAL activity

On Wed, Jun 19, 2013 at 4:22 PM, Sean Dillon wrote: > Just turned on WAL archiving to an S3 bucket for a small database - total > size of perhaps 2-4G. After turning on achiving, we're seeing WAL logs > written to S3 at the rate of about 1G every 3 minutes. That seems > completely unreasonable g

Re: [ADMIN] PostgreSQL 8.4 - permissions for newly created tables?

I can also make this lead programmer an owner of the newly created database instead of giving him ALL permissions. "owner" is better than "all"? 2013/6/20 Rafał Radecki > Hi All. > > I have to setup a new infrastructure with postgre software. I would like > to use user access patterns from mysq

[ADMIN] PostgreSQL 8.4 - permissions for newly created tables?

Hi All. I have to setup a new infrastructure with postgre software. I would like to use user access patterns from mysql if possible. For every application: 1) one user for reads: grant select on db.* to 'reader'@'ip space' ...; 2) one user for reads/writes: grant update,insert,select,delete on db.

Re: [ADMIN] Why sequence grant is separated from table?

On 19/06/2013 12:47, Szymon Guz wrote: On 19 June 2013 11:35, Rural Hunter > wrote: I really hate the error "permission denied for sequence x" when I grant on a table but forget to grant additionally on the related sequence to users. Can the permissi

Re: [ADMIN] Composite Unique Key - Doubt

Technical Doubts wrote on 20.06.2013 09:42: technologies ( technologyid bigint, status character(1), implementeddate date *CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)* ) entering data as insert into technologies (technologyid,status,implementeddate) values (123,'P'

Re: [ADMIN] Composite Unique Key - Doubt

On Thu, 20 Jun 2013 10:42:37 +0300, Technical Doubts wrote: Team, Am using Postgres 9.2 I am having a table technologies ( technologyid bigint, status character(1), implementeddate date *CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)* ) entering data as inse

[ADMIN] Composite Unique Key - Doubt

Team, Am using Postgres 9.2 I am having a table technologies ( technologyid bigint, status character(1), implementeddate date *CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)* ) entering data as insert into technologies (technologyid,status,implementeddate) values (12