Re: [ADMIN] Pg 9.1 master-slave replication

2013-02-20 Thread Gilberto Castillo
.cu > Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com> > Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com&

Re: [ADMIN] top posting?

2013-05-06 Thread Gilberto Castillo
t;only bottom post" > idea? > > (I'm not trying to start a flame war, just genuinely curious.) > Prefer a brief note of what this issue, to follow in him. And not I have to go elsewhere to find out whether or not interest me the news, avoid to nuisance. Saludos, Gilberto Casti

Re: [ADMIN] Migration of server

2013-05-16 Thread Gilberto Castillo
an guide me about what steps i have to do > exactly and considerations during this process. Not, only bad thing is that the 9.3 is still in beta version. Use 9.2. Write list in spanish Too ;-) Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail

Re: [ADMIN] Creating new cluster by copying directory?

2013-07-11 Thread Gilberto Castillo
g_ctlcluster 9.1 test start > > Is this viable? If not, is there another way to create a duplicate cluster > in a timely fashion? Test Repmgr works with the same philosophy. ;-) Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28

Re: [ADMIN] Creating new cluster by copying directory?

2013-07-11 Thread Gilberto Castillo
> So it's safe to copy the files in /var/lib/postgresql/9.1/main to > /var/lib/postgresql/9.1/test while main is running? > Yes, but the server where copy is stop. Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELE

Re: [ADMIN] restoring a table after an online backup

2013-07-15 Thread Gilberto Castillo
ith SQL, you can find to with the sql of the table you want. Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com> -

Re: [ADMIN] Help with PITR in PostgreSQL 8.4

2013-07-17 Thread Gilberto Castillo
;rm -f /var/run/postgresql/8.4-main.trigger' > > EOF > > Hello Nestor I use its: standby_mode = 'on' primary_conninfo = 'host=X.X.X.X port=5432 user= password=YTT' trigger_file = '/var/pgsql/data/pg_failover_trigger' restore_command = 'c

Re: [ADMIN] Help with PITR in PostgreSQL 8.4

2013-07-17 Thread Gilberto Castillo
rsync every > time I recover the standby database (8.4) > See you: http://www.postgresql.org.es/node/238 http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host

Re: [ADMIN] PGPOOL II No funciona agrupamiento de conecciones

2013-09-06 Thread Gilberto Castillo
on. ¿Qué te hace pensar que no esta reutilizando tus conexiones? Saludos, Gilberto Castillo La Habana, Cuba --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com> --

Re: [ADMIN] postgres database user account

2010-06-30 Thread Gilberto Castillo Martínez
; (or create roles) that accomplish what they need. > or only allow IP connections and remove the sock LOCAL and remove ALL of pg_hba Usuaris -- Redards, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Etecsa. Miramar, La Haban.Cuba. --- This message was processed by Kaspersky Mail

Re: [ADMIN] Listen on IPv6 only

2011-03-09 Thread Gilberto Castillo Martínez
n IPv6 only: > > root@cajones:~# telnet 127.0.0.1 5432 > Trying 127.0.0.1... > telnet: Unable to connect to remote host: Connection refused > > root@cajones:~# telnet ::1 5432 > Trying ::1... > Connected to ::1. > Escape character is '^]'. > > Might be an

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
> > Maybe!!. > > Interesting. How would someone listen only on IPv4 addresses? In documentation there are few examples of its use, there are several networks that only use IPv6 -- Saludos, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Etecsa. Miramar, La Habana.Cub

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
> My big question is whether '::' is supported on all platforms that > support IPv6, and whether there is an IPv4-only syntax. Umm, you have to try, at least there is not much documented about it. -- Saludos, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Ete

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
> OK, let's skip documenting this then. They can already do this via > pg_hba.conf. What would the postgresal.conf listen_addresses? -- Saludos, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Etecsa. Miramar, La Habana.Cuba. --- This message was processed by Kas

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
main# telnet ::1 5432 > Trying ::1... > telnet: Unable to connect to remote host: Connection refused > > root@toad:/etc/postgresql/8.4/main# telnet 127.0.0.1 5432 > Trying 127.0.0.1... > Connected to 127.0.0.1. > Escape character is '^]'. > OK, -- Saludos, Gilberto

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
inking you should put that information somewhere accessible comun. -- Saludos, Gilberto Castillo Edificio Beijing. Miramar Trade Center. Etecsa. Miramar, La Habana.Cuba. --- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx2.etecsa.cu Visit our web-site: <http:

Re: [ADMIN] Listen on IPv6 only

2011-03-10 Thread Gilberto Castillo Martínez
_addresses prevents anyone from even binding to the address. > > > > I keep thinking you should put that information somewhere accessible > > comun. > > I can add it to the documentation now that we have more reports. Thank you!! -- Saludos, Gilberto Castillo Edificio Bei

Re: [ADMIN] constraint triggers

2011-09-28 Thread Gilberto Castillo Martínez
E dataset > SET gracount = gracount + 1 > WHERE dataset.inv_id = NEW.inv_id; >END IF; > RETURN NULL; > END; > $BODY$ > LANGUAGE plpgsql VOLATILE > COST 100; > ALTER FUNCTION increment_dataset_granule_count() OWNER TO jboss; >