Re: [ADMIN] Need Help in creating script

2001-05-17 Thread Oliver Elphick
"Prashant Sinha" wrote: >I am a new postgre user. I had used sql commands to create database and tab= >les. Is it possible to create a script or installable version on existing d= >atabase which I could run on any machine and it would crearte the database = >with all the tables and everyth

[ADMIN] process idle

2001-05-17 Thread Didier Bretin
Hello, I'm under linux with version 7.0. If I do a `ps` I got: postgres 31838 0.8 2.0 5128 2652 pts/9S14:50 0:49 /mnt/commun/local/postgresql-7.0/bin/postgres 127.0.0.1 nobody wiki idle What means 'idle' ? Do I need to kill them to free memory ? Thanks. -- .--

[ADMIN] Importing data from ms-sql

2001-05-17 Thread Johan Segernäs
Title: Importing data from ms-sql I need a way to get my linux/debian with postgresql to import data from a ms-sql server. is there anyone out there with a good tips how to do this? i'd like to run a script or something every night to update some dates from our internal admin-system and then