[ADMIN] reinstalling postgres on windows

2006-07-02 Thread Dragan Matic
e postgres account name for service installation since I don't know the password. Where can I delete this postgres account? Thanks in advance, Dragan Matic ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[ADMIN] checking if user is connected as a superuser?

2005-06-06 Thread Dragan Matic
Is there a way to check if user is a superuser for the given cluster? Thanks in advance Dragan ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTE

[ADMIN] read-only database on CD-ROM?

2005-03-26 Thread Dragan Matic
ld be possible or link to documentation. Thanks in advance Dragan Matic ---(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

Re: [ADMIN] Fixing "old version was found" error

2005-03-22 Thread Dragan Matic
Erase /var/lib/pgsql/data directory and all its subdirectories Gordon A. Fox wrote: I just upgraded a machine to Fedora Core 3 and now on startup pgsql gives me the message "An old version of the database format was found" and refuses to start. I'm not entirely sure how to fix this (everything I've

[ADMIN] How can I backup database from database itself

2004-06-24 Thread Dragan Matic
Is there a way to backup a database by issuing an SQL statement from the database? I would like user to be able to create a backup from database itself, and not by telnetting to server and typing 'pg_dump' or 'pg_dumpall'. Tnx in advance Dragan ---(end of broadcast)-