Re: [ADMIN] broken restore.sql script !?

2006-02-22 Thread Christian Sengstock
hi again, 2006/2/22, Tom Lane <[EMAIL PROTECTED]>: "Christian Sengstock" <[EMAIL PROTECTED]> writes: > The function is created outside of the 'geo' schema, but after that, the> 'alter function' statement tries to alter the function inside of the &#

[ADMIN] broken restore.sql script !?

2006-02-22 Thread Christian Sengstock
hi list, i have a auto-generated restore.sql script which doesn't work for me because of an obvious error inside of it. because the script is working for other people i thought of an os error (i use linux, others windows). the problem: The function is created outside of the 'geo' schema, but af

Re: [ADMIN] Copy database

2006-01-30 Thread Christian Sengstock
2006/1/30, Uwe C. Schroeder <[EMAIL PROTECTED]>: On Monday 23 January 2006 00:49, Krzysztof Szadkowski wrote:> Hi all,>> I am looking for a way to copy whole database to another existing > database.> Any suggestions ?   Sometimes you want to copy the whole DBMS to another machine where the same po

Re: [ADMIN] Postgres, logs, dumps y bases de datos descentralizadas.¿?

2006-01-20 Thread Christian Sengstock
en las que he pensado no me parecen adecuadas. Ayudenme por favor si han realizado algo parecido alguna vez o tienen alguna idea de cómo hacer esto...Gracias...Yessica Brinkmann Baruja. -- Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671

[ADMIN] problem with dead 'drop table' process

2006-01-20 Thread Christian Sengstock
?   D   07:58   0:00 postgres: postgres wlan [local] DROP TABLE i cannot kill it with kill -9, and also i'm not sure if i should. maybe the database is not running after it at all? anyone got any hints? thanx, chris -- Christian Sengstock - Tel: 06221 / 650 5889, Mob: 0178 / 38 79 671