Re: [ADMIN] Ubuntu Precise and auto startup of pg databases

2013-06-27 Thread Magnus Hagander
On Sun, Jun 23, 2013 at 1:16 AM, Christofer C. Bell wrote: > On Sat, Jun 22, 2013 at 2:49 PM, Tom Lane wrote: >> >> Tony Dare writes: >> > I don't know if anyone else has had this problem but i found that the >> > /etc/init.d/postgresql script simply would not start up my databases >> > after a

Re: [ADMIN] Partial dump backup -T parameter and sequence incorrect inclusion

2013-06-27 Thread Sergey Konoplev
On Thu, Jun 27, 2013 at 9:47 AM, Daniel Vázquez wrote: > Postgres 9.1 > > pg_backup with -T parameter excluding dump explicit table. Then when > pg_restore any object of excluded table are restored EXCEPT the sequence. > That's a problem because if use -c to clean try to drop existent sequence > o

Re: [ADMIN] pg_upgrade / postgis issue

2013-06-27 Thread Sergey Konoplev
On Thu, Jun 27, 2013 at 11:29 AM, Marcos Cano wrote: > so after following the steps, and going with the pg_upgrade i get an issue > with the content in the DB > > fatal > > Your installation contains the "name" data type in user tables. This > data type changed its internal alignment between you

Re: [ADMIN] pg_upgrade / postgis issue

2013-06-27 Thread Marcos Cano
so after following the steps, and going with the pg_upgrade i get an issue with the content in the DB fatal Your installation contains the "name" data type in user tables. This data type changed its internal alignment between your old and new clusters so this cluster cannot currently be upgrade

Re: [ADMIN] pg_upgrade / postgis issue

2013-06-27 Thread Sergey Konoplev
(please, don't forget to put the list in CC when replying) On Thu, Jun 27, 2013 at 9:40 AM, Marcos Cano wrote: > i got some errors in some databases like: > psql:postgis_upgrade_13_to_15.sql:5259: ERROR: current transaction is > aborted, commands ignored until end of transaction block You shoul

[ADMIN] Partial dump backup -T parameter and sequence incorrect inclusion

2013-06-27 Thread Daniel Vázquez
Hi here! Postgres 9.1 pg_backup with -T parameter excluding dump explicit table. Then when pg_restore any object of excluded table are restored EXCEPT the sequence. That's a problem because if use -c to clean try to drop existent sequence object and then raises dependency error. Thanks!

Re: [ADMIN] pg_upgrade / postgis issue

2013-06-27 Thread Sergey Konoplev
On Thu, Jun 27, 2013 at 9:30 AM, Marcos Cano wrote: > just one last question how do i know if after doing a soft_upgrade (from 1.3 > to 1.58) everything went ok? No errors during upgrade plus test your geo features afterwards. > > > On Thu, Jun 27, 2013 at 10:13 AM, Sergey Konoplev wrote: >> >>