Re: [ADMIN] Is pgdump_all == pg_dumpall -g + pg_dump of individual databases ?

2005-09-23 Thread Robert Treat
On Thursday 22 September 2005 05:14, Rajesh Kumar Mallah wrote: > Hi , > > I suppose pgdump_all creates a SQL script > that is capable of recreating the entire database > except for large_objects. > > However pgdump_all produces one single large > SQL files and is not useful(easy) if one has to re

Re: [ADMIN] postgresql cluster on SAN

2005-09-23 Thread Chris Travers
Spiegelberg, Greg wrote: This is possible. Below is a brief recipe. 1. Use Veritas Storage Foundation HA with Cluster File System. 2. Have a volume with cfs available to 2 or more systems via SAN. 3. Install PostgreSQL and be sure PGDATA is on the cfs mount 4. Create a Storage Checkpoint of cf

Re: [ADMIN] Encrypted Disks

2005-09-23 Thread Peter Darley
Scott, I was hoping that someone with some experience could comment on how much this would slow down PostgreSQL, or weither it is likely to introduce some instabilities... Thanks, Peter Darley -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Marl

Re: [ADMIN] Encrypted Disks

2005-09-23 Thread Scott Marlowe
Well then, a loop back mounted encrypted file system should do the trick. Note that other methods could work as well, but not require an encrypted file system, such as two key (public/private i.e. pki) encryption, where the key used for encrypting could be kept on the server, and the decryption ke

Re: [ADMIN] Encrypted Disks

2005-09-23 Thread Peter Darley
Scott, The only potential scenario for us is encrypting the disks so if they are stollen the data is safe. It's a small project and it would not be worth it to redesign our system to the extent it would need to be to have data in the fields encrypted while the db is running. So, long an

Re: [ADMIN] alter user

2005-09-23 Thread Scott Marlowe
On Thu, 2005-09-22 at 19:32, Wim Bertels wrote: > On Friday 23 September 2005 01:51, Scott Marlowe seinde rooksignalen: > > Instead of using a general purpose account, why not give everyone an > > account, then make them a member of a group, and give that group the > > access. > > > > That way you

Re: [ADMIN] Encrypted Disks

2005-09-23 Thread Scott Marlowe
On Thu, 2005-09-22 at 17:18, Peter Darley wrote: > Folks, > > A client is asking us about data security, and keeping data encrypted on > disk. I recall there was some discussion about this before, including > things like for it to be secure an operator would need to put in a key when > the

Re: [ADMIN] COPY TO / COPY FROM

2005-09-23 Thread Michael Fuhr
On Fri, Sep 23, 2005 at 01:48:33PM +0200, Cédric Buschini wrote: > = > psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF > /home/postgres/FILE > COPY TABLE TO stdout; > EOF > > psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF > COPY carax_exec_bck FROM '/home/postgres/FIL

Re: [ADMIN] postgresql cluster on SAN

2005-09-23 Thread Spiegelberg, Greg
This is possible. Below is a brief recipe. 1. Use Veritas Storage Foundation HA with Cluster File System. 2. Have a volume with cfs available to 2 or more systems via SAN. 3. Install PostgreSQL and be sure PGDATA is on the cfs mount 4. Create a Storage Checkpoint of cfs mount (read-write virtual

Re: [ADMIN] COPY TO / COPY FROM

2005-09-23 Thread Aldor
Why you don't make: COPY carax_exec_bck TO '/home/postgres/FILE'; ? Then you could also use something like COPY carax_exec_bck TO '/home/postgres/FILE' WITH BINARY; etc. Cédric Buschini wrote: > Hi > > Here I am again with my 'stupd' question > > here is a script : > >

[ADMIN] COPY TO / COPY FROM

2005-09-23 Thread Cédric Buschini
Hi Here I am again with my 'stupd' question here is a script : = psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF > /home/postgres/FILE COPY TABLE TO stdout; EOF psql -h192.168.XXX.XXX -dDATABASE -Upostgres << EOF COPY carax_exec_bck FROM '/home/postgres/FILE'; EOF

Re: [ADMIN] Replication

2005-09-23 Thread Aldor
>Are there any non-statement level solution? Something that appends to the WAL >> on the slave server? For this kind of solution I'm also looking for a while - but in the meantime you can also take a look at "slony" - it can do really many things. Don't give up at the beginning, after you've u

Re: [ADMIN] vacuum message

2005-09-23 Thread Hannes Dorbath
On 23.09.2005 08:01, Adrian Engelbrecht wrote: You need to increase your max_fsm_pages to at least 29584 pages to accommodate / monitor all free pages. Better set it to much more to have some room for future growth, 5 maybe. -- Regards, Hannes Dorbath ---(end of b

Re: [ADMIN] Hi.........

2005-09-23 Thread Hannes Dorbath
On 23.09.2005 09:27, sandhya wrote: 1) To Display all the databases under Particular user 3) To Display the permissions of the users 4) To Display the tables and Access permissions of it under a database start psql with -E option then type \? and choose what you need. 2) To Display the timing

[ADMIN] Hi.........

2005-09-23 Thread sandhya
Is there any way/any SQL query of getting information regarding users. Like 1) To Display all the databases under Particular user 2) To Display the timings of login and logout of the databases of other users. 3) To Display the permissions of the users 4) To Display the tables and Access