Re: [ADMIN] Win32-postgresql command line password

2005-02-10 Thread Pascal Van Puymbroeck
I'm not sure if this is the best method but I use the: pgsql -d dbase -U ppk -f e:\\Test.imp < passwd.txt Where passwd.txt holds the password for the user specified. Hope this helps you out. Pascal Van Puymbroeck ZENON productions bvba ---(end of b

Re: [ADMIN] Performance issue

2005-02-05 Thread Pascal Van Puymbroeck
OK, I found the thread you mentioned and installed the Qos Service on my win2K netwerk, but it gave no effect. So it must be something else in this case. Pascal Van Puymbroeck ZENON productions bvba ---(end of broadcast)--- TIP 7: don't forg

[ADMIN] Performance issue

2005-02-05 Thread Pascal Van Puymbroeck
by a performance slowdown ? Thanks Pascal Van Puymbroeck ZENON productions bvba ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match