Re: [ADMIN] Regarding a backup scenario

2005-07-12 Thread Thomas F. O'Connell
Could you use Slony-I's recently added log shipping feature? http://slony.info/ -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open Source: Open Your i™ http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Jul 11, 2

[ADMIN] How to list user accounts?

2005-07-12 Thread Thanh Q Lam
Hi, Is there a command/option to list all database user accounts in postgres? Thanks, Thanh ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] How to list user accounts?

2005-07-12 Thread Scott Marlowe
On Tue, 2005-07-12 at 13:59, Thanh Q Lam wrote: > Hi, > > Is there a command/option to list all database user accounts in postgres? >From the psql monitor: \du via sql: SELECT u.usename AS "User name", u.usesysid AS "User ID", CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, cr

Re: [ADMIN] How to list user accounts?

2005-07-12 Thread Bruno Wolff III
On Tue, Jul 12, 2005 at 14:59:27 -0400, Thanh Q Lam <[EMAIL PROTECTED]> wrote: > > Is there a command/option to list all database user accounts in postgres? select usename from pg_user; ---(end of broadcast)--- TIP 5: don't forget to increase you

Re: [ADMIN] How to list user accounts?

2005-07-12 Thread Michael Fuhr
On Tue, Jul 12, 2005 at 02:59:27PM -0400, Thanh Q Lam wrote: > > Is there a command/option to list all database user accounts in postgres? If you're using psql then see "Meta-Commands" in the psql documentation; otherwise see your client's documentation. You could also query the system catalogs

[ADMIN] Help for postgresql binary installation v.8.0.3

2005-07-12 Thread Jana Nguyen
Hi there, I am installing postgresql v. 8.0.3 binary on a redhat linux rhel 3.0. What rpms are needed and in what order for installation since I see a slew of rpms below. It be great if there is documentation for binary installation for postgresql v.8+ as well. If so, let me know. postgresql-

[ADMIN] Specified driver could not be loaded due to system error 998 (PostgreSQL).

2005-07-12 Thread Joel Fradkin
I tried the connx drivers today (did not work for me). After deleting them I get this error. I tried removing postgres completely searched for any libpq.dll (saw a reference to that maybe the issue in archives). I removed any reference to postgres from the registry. Re-installed 8.0.3

[ADMIN] got my odbc working(re-loaded mdac as well as postgres) but it started working after I added a dsn (not using a dsn connection though so odd)

2005-07-12 Thread Joel Fradkin
Specified driver could not be loaded due to system error 998 (PostgreSQL). Not sure why it started (happened after I tried connx, but could be completely unrelated). Any how its working now. I re-loaded mdac and it still did not work (also re-loaded postgres). It started after I added a

[ADMIN] Postgres service user keeps losing password

2005-07-12 Thread Karim Mardhani
Hi All:   I am having an interesting problem with the user which starts postmaster as service.   I am using postgres 8.0.1 as backend to my stand alone windows application.  My installation program installs postgres in silent mode and sets it to start as windows service.  Before installing po

Re: [ADMIN] Help for postgresql binary installation v.8.0.3

2005-07-12 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 12 Jul 2005, Jana Nguyen wrote: I am installing postgresql v. 8.0.3 binary on a redhat linux rhel 3.0. What rpms are needed and in what order for installation since I see a slew of rpms below. If you download all RPMs and run rpm -q