Re: [ADMIN] Vacuum taking forever

2007-03-21 Thread Phillip Smith
What are the specs of your machine? What is the memory settings in your postgresql.conf file? Cheers ~p On Wed, 2007-03-21 at 19:42 -0700, Davidson, Robert wrote: > df –h reports 806 MB free and 79 GB used. Is this enough free space to > perform a vacuum? Should I export the table, drop it, and r

Re: [ADMIN] Vacuum taking forever

2007-03-21 Thread Joshua D. Drake
Davidson, Robert wrote: > I am doing a vacuum full on a table that takes up 78 GB of a 79 GB HD. When I > couldn't add any more data because of out of disk space errors, I freed up > space by dropping other tables in the database. I was able to delete about > half the records in the table, but t

[ADMIN] Vacuum taking forever

2007-03-21 Thread Davidson, Robert
I am doing a vacuum full on a table that takes up 78 GB of a 79 GB HD. When I couldn't add any more data because of out of disk space errors, I freed up space by dropping other tables in the database. I was able to delete about half the records in the table, but the space consumption did not cha

Re: [ADMIN] [SQL] Monitor what command is executing at the backend

2007-03-21 Thread George Pavlov
> How will I enable command string to see the commands? in your postgresql.conf set stats_command_string = true read http://www.postgresql.org/docs/8.2/interactive/monitoring-stats.html for details ---(end of broadcast)--- TIP 7: You can help sup

Re: [ADMIN] [SQL] Monitor what command is executing at the backend

2007-03-21 Thread Karthikeyan Sundaram
George, How will I enable command string to see the commands? Regards skarthi From: "George Pavlov" <[EMAIL PROTECTED]> To: "Karthikeyan Sundaram" <[EMAIL PROTECTED]>,, Subject: Re: [SQL] Monitor what command is executing at the backend Date: Wed, 21 Mar 2007 14:56:50 -0700 >Is there

Re: [ADMIN] [SQL] Monitor what command is executing at the backend

2007-03-21 Thread George Pavlov
>Is there a way to see from the log files on what sql statement is > currently by which user? In other words, I want to monitor > the DB activity. for a current snapshot you don't need the logs, try: select * from pg_stat_activity; (command string needs to be enabled for your database.)

[ADMIN] Monitor what command is executing at the backend

2007-03-21 Thread Karthikeyan Sundaram
Hi everybody, Is there a way to see from the log files on what sql statement is currently by which user? In other words, I want to monitor the DB activity. How can I find it? Regards skarthi _ Get a FREE Web site, company

Re: [ADMIN] Read-only access to a database

2007-03-21 Thread Karthikeyan Sundaram
when you create a role, you can specify, nocreate option. Then when you grant the tables to this user give only select privilege. Regards skarthi From: "Brian A. Seklecki" <[EMAIL PROTECTED]> To: "Morten W. Petersen" <[EMAIL PROTECTED]> CC: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Rea

Re: [ADMIN] Read-only access to a database

2007-03-21 Thread Brian A. Seklecki
Wouldn't you just set read-only ACLs for that role on all of the objects in the database in question? ~BAS On Wed, 2007-03-21 at 17:42 +0100, Morten W. Petersen wrote: > Hi, > > I'd like to create a user that has read-only access to > a database. > > I've read the docs and fumbled around a bit

[ADMIN] Read-only access to a database

2007-03-21 Thread Morten W. Petersen
Hi, I'd like to create a user that has read-only access to a database. I've read the docs and fumbled around a bit (even tried to use phppgadmin) - but nothing works. "CREATE USER username" is about as far as I've gotten. Which other commands would I have to use to enable read-only access to a

Re: [ADMIN] growth of the database

2007-03-21 Thread Guido Neitzer
On 21.03.2007, at 11:25, Karthikeyan Sundaram wrote: Our database is growing fast. I want to create a cronjob that should tell me what is the current size of the database on each day. How can I find this from the database? Is there any pre-written scripts written by somebody to shar

[ADMIN] growth of the database

2007-03-21 Thread Karthikeyan Sundaram
Hi, Our database is growing fast. I want to create a cronjob that should tell me what is the current size of the database on each day. How can I find this from the database? Is there any pre-written scripts written by somebody to share? Regards skarthi _

Re: [ADMIN] RPMs for RedHat 5 Enterprise?

2007-03-21 Thread Devrim GÜNDÜZ
Hi, On Wed, 2007-03-21 at 07:33 -0700, Benjamin Arai wrote: > When and are rpms going to be released for RedHat 5? Probably on Monday. I will have the isos on Sunday. Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedi

[ADMIN] RPMs for RedHat 5 Enterprise?

2007-03-21 Thread Benjamin Arai
Hi, When and are rpms going to be released for RedHat 5? Benjamin ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate

Re: [ADMIN] which distro, or to build

2007-03-21 Thread Joshua Kramer
David, I'm not sure what dependencies the RH-provided PG RPM's have, but I've had no problems whatsoever installing a series of PG-sourced RPM's from 8.1 on up to 8.2.3, on CentOS 4 (which is binary-compatible with RHEL4). Actually, there is one minor glitch; some apps that use PG require an