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

[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

[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] 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] 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-

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

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 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

[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] 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