[ADMIN] how can I retreive Users,Groups and Permissions

Hi all, I am new to PostgreSQL. May I how can I retreive Users,Groups and Permissions form System Tables. Regards, Sreedhar ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [ADMIN] Filesystem Backup

Well the pg_dump(all) utils give a version mismatch, I guess my DB is 7.1.3 and the utils are some other version (how do I check the versions correctly?) dunno how that happened. How can I upgrade the utils and leave the DB engine untouched? It's a redhat linux box so rpms would be preferrd. Than

Re: [ADMIN] Filesystem Backup

If I understand correctly, the only time a pure file system restore would work to put back your data was if the instance was down when the file systems were backed up.  Otherwise, pg_dump of a database, or pg_dumpall of the whole instance would be necessary.  If you were doing this for some oth

Re: [ADMIN] Maximum Performance -> File System?

On Sat, 26 Jan 2002, Jean Huveneers wrote: > And multi-processor usage depends on your linux kernel. Or FreeBSD or anything else of course. > But what is the best file system to use? > I'm going to run postgres on a IDE-RAID5 (hardware from 3Ware) ATA-100 > system, total capacity around the 160

Re: [ADMIN] Where can I get Users and Roles information in PostgreSQL

On Mon, 4 Feb 2002, sreedhar wrote: > Hi all, > > I am new bee to PostgreSQL. Where can I get Users and Roles information in > PostgreSQL. > > eg : In SQL-SERVER we can get users information using 'sysusers' table. > > advance thanks for helping, I'm new too, so this may not be the best answer,

[ADMIN] Where can I get Users and Roles information in PostgreSQL

Hi all, I am new bee to PostgreSQL. Where can I get Users and Roles information in PostgreSQL. eg : In SQL-SERVER we can get users information using 'sysusers' table. advance thanks for helping, regards, sreedhar ---(end of broadcast)--- TIP 2: