-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
(This is a repost because the original was send when I was not
subscribed to the list and it is still not approved - sorry if you
received it already.)
I have installed a script that executes vacuumdb for all DBs in my
cluster (run by cron every nigh
Hmm.. I was trying simplify my function to get the point across with
minimal confusion. If you don't think there is enough detail, let me
know what is lacking and I will add the appropriate detail. The
function is executed BEFORE insert on table1. Thanks again for the help all
Kris
Tom Lane
"Milen A. Radev" <[EMAIL PROTECTED]> writes:
> I review the log every morning. In the beginning I got "wraparound
> failure" warnings every third day. But from a week I got those warnings
> every day. Well we have one table in one database where there are a lot
> of inserts, but not that many - aro
Kris Kiger <[EMAIL PROTECTED]> writes:
> Hmm.. I was trying simplify my function to get the point across with
> minimal confusion. If you don't think there is enough detail, let me
> know what is lacking and I will add the appropriate detail. The
> function is executed BEFORE insert on table1.
On Thu, Mar 10, 2005 at 11:19:03AM +0200, Milen A. Radev wrote:
> exec /usr/local/pgsql/bin/vacuumdb -U postgres -h localhost \
> - --all --analyze >>$PG_VACUUM_LOG 2>&1
My first thought was that the lone hyphen at the beginning of the
script's last line might be causing an end of option processi
I wrote:
> "Milen A. Radev" <[EMAIL PROTECTED]> writes:
>> I review the log every morning. In the beginning I got "wraparound
>> failure" warnings every third day. But from a week I got those warnings
>> every day. Well we have one table in one database where there are a lot
>> of inserts, but not
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Michael Fuhr wrote:
> On Thu, Mar 10, 2005 at 11:19:03AM +0200, Milen A. Radev wrote:
>
>
>>exec /usr/local/pgsql/bin/vacuumdb -U postgres -h localhost \
>>- --all --analyze >>$PG_VACUUM_LOG 2>&1
>
>
> My first thought was that the lone hyphen at t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Tom Lane wrote:
> I wrote:
>
>>"Milen A. Radev" <[EMAIL PROTECTED]> writes:
>>
>>>I review the log every morning. In the beginning I got "wraparound
>>>failure" warnings every third day. But from a week I got those warnings
>>>every day. Well we have
Hi,
Can anybody know how the following statement work.
Grant ALL on SCHEMA test to user 'user1';
will the user be able to have all the privileges on
all the objects/tables on schema test? Or he can only
create new objects in that schema.
Thanks
Priya
"Milen A. Radev" <[EMAIL PROTECTED]> writes:
> Two queries - 2 seconds apart:
> template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
> datname | age
> - ---+-
> xxx1 | 1519763573
> template1=# SELECT datname, age(datfrozenxid) FROM pg_database;
> dat
Hi all
Is it possible to create another administrator
for PostgreSQL server ? I am using Postgres 7.4.6
thanks in advance !
regards
Gaurav Arora
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.ya
On Thu, 2005-03-10 at 12:49, Gaurav Arora wrote:
> Hi all
>
> Is it possible to create another administrator
> for PostgreSQL server ? I am using Postgres 7.4.6
Yep. Any user with authority to create new users is an administrator
(or more commonly a "superuser")
--
I have a question about IO timeouts:
We are using the 3ware escalade 9500S series of cards, and we had a
drive failure this morning. Apparnetly the card waits 30 seconds for
the drive to respond, and if it doesn't, it put's the drive in a fail
state. Postgres it seems didn't wait 30 seconds befo
On Thu, Mar 10, 2005 at 10:49:20AM -0800, Gaurav Arora wrote:
> Is it possible to create another administrator
> for PostgreSQL server ? I am using Postgres 7.4.6
See the documentation for createuser, CREATE USER, and the "User
Attributes" section in the "Database Users and Privileges" chap
Hi,
When I read doc, http://www.powerpostgresql.com/PerfList/,
I am confused by:
“maintenance_work_mem: formerly called vacuum_mem, this is the quantity of RAM
PostgreSQL uses for VACUUM, ANALYZE, CREATE INDEX, and adding foriegn keys.”
Is this right? I
thought work_mem (or sort_me
All,
I visited #postgresql @ FreeNode and asked about how to make pg use pam
about a week ago (specifically I wanted to auth against LDAP). I was
told to figure it out and write a doc...
Here is my attempt at doing so: http://itc.musc.edu/wiki/PostGreSQL
Please review for accuracy and/or proo
In your second paragraph, I think that you are saying that SELECT FOR
UPDATE only locks one row, even though the select itself may return
many. Am I mis-interpreting you? Also, what do you mean by seizing on
a non-active row?
Your assumption about pkey_id is right, I meant for that to mean p
Alex Turner <[EMAIL PROTECTED]> writes:
> I have a question about IO timeouts:
> We are using the 3ware escalade 9500S series of cards, and we had a
> drive failure this morning. Apparnetly the card waits 30 seconds for
> the drive to respond, and if it doesn't, it put's the drive in a fail
> stat
"Lee Wu" <[EMAIL PROTECTED]> writes:
> "maintenance_work_mem: formerly called vacuum_mem, this is the quantity
> of RAM PostgreSQL uses for VACUUM, ANALYZE, CREATE INDEX, and adding
> foriegn keys."
> Is this right? I thought work_mem (or sort_mem prior 8) is used for
> CREATE INDEX.
Yes it is ri
Kris Kiger <[EMAIL PROTECTED]> writes:
> In your second paragraph, I think that you are saying that SELECT FOR
> UPDATE only locks one row, even though the select itself may return
> many. Am I mis-interpreting you?
No, I'm saying that plpgsql's SELECT INTO operation only reads one row.
The fac
I use PostgreSQL 8!
I have 2 file:
insert.htmUntitled Document
postgre_insert.jsp<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="" %><% String username=request.getParameter("username"); String str="insert into user_table values('"+username+"','try')"; Clas
Well - I am sort of trying to piece together exactly what happened.
Here's what I know.
Around 02:52 I get messages in my syslog stating that there were
problems writing to a controler channel:
Mar 10 02:52:29 tsunami kernel: 3w-9xxx: scsi1: WARNING:
(0x06:0x002C): Unit #1: Command (0x28) timed o
Dmitry Morozovsky wrote:
> On Tue, 22 Feb 2005, Chris White (cjwhite) wrote:
>
> CWc> We are noticing on our 7.4.5 system the following files are being written
> CWc> approximately every 5 minutes
> CWc>
> CWc> /tmp/.s.PGSQL.5432
> CWc> /tmp/.s.PGSQL.5432.lock
> CWc>
> CWc> Anybody know why they
Alex Turner <[EMAIL PROTECTED]> writes:
> Well - I am sort of trying to piece together exactly what happened.
> Here's what I know.
> Around 02:52 I get messages in my syslog stating that there were
> problems writing to a controler channel:
> [ various hardware errors snipped ]
> At around 07:30
Bruce Momjian writes:
> I am now thinking we need to make this "10" a GUC variable for just such
> cases. This is not the first request for this.
At most it's the second or third request ... and this is hardly the only
repetitive disk hit in Postgres. I can't get excited about it.
How can I automatically have PostgreSQL prompt for a
password everytime I do the following to connect to my
sample databaase 'movies'?
I installed the database correctly to exact
instructions in the INSTALL doc in the PostgreSQL
source directory in /usr/local and it is now
registered as a daemon i
First, I would try to set encoding (charset) for the insert.htm page to
UTF-8. That might help. If not, let us know.
Miroslav Åulc
star star wrote:
I use PostgreSQL 8!
I have 2 file:
insert.htm
Untitled Document
postgre_insert.jsp
<%@ page contentType="text/html; charset=utf-8" import=
27 matches
Mail list logo
