Re: [GENERAL] Is there a plugin/script for nagios that monitors pitr being up to djavascript:;ate?

On Fri, 2010-10-22 at 10:25 -0400, Chris Barnes wrote: > It's Escaping me where nagios is in the listing? I'm probably way off > but more specifically if you could please? See cmd_archiver.ini file, mainly notify_ok, notify_warning and notify_critical parameters. Using nsca+nagios, you can send pa

Re: [GENERAL] What is better method to backup postgresql DB.

> In response to Steeles : > > new to postgresql. need to backup postgresql DB, which way is better to > > backup DB. > > > > from training, I learned that we can backup the whole PGdata and other > > directories to achieve backup goal, originally I was planned to schedule > > jobs to use pgdump

Re: [GENERAL] DB become enormous with continuos insert and update

Hi, Il 27/10/10 00:22, Hfe80 ha scritto: The problem is that updates need more space becouse datas is not overwritten in the same space... As I said earlier, we need to know which PostgreSQL version you are using. PostgreSQL 8.3 introduced Heap Only Tuples (HOT) updates. Is it at least an 8.

Re: [GENERAL] Advice needed on application/database authentication/authorization/auditing model

On 27/10/10 04:49, Dmitriy Igrishin wrote: > Hey Tony, > > 2010/10/27 Tony Cebzanov > > > On 10/23/10 11:01 AM, Craig Ringer wrote: > > Yep. As for not explicitly mentioning "lower" roles when granting a > > higher role (ie "admin" isn't also a "user")

Re: [GENERAL] PostgreSQL 32 bit DB on 64 bit machine

On 27/10/10 08:34, Dann Corbit wrote: >> -Original Message- >> From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- >> ow...@postgresql.org] On Behalf Of Joshua D. Drake >> Sent: Tuesday, October 26, 2010 5:18 PM >> To: Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC] >> Cc:

Re: [GENERAL] PostgreSQL 32 bit DB on 64 bit machine

> -Original Message- > From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general- > ow...@postgresql.org] On Behalf Of Joshua D. Drake > Sent: Tuesday, October 26, 2010 5:18 PM > To: Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC] > Cc: pgsql-general@postgresql.org > Subject: Re:

Re: [GENERAL] PostgreSQL 32 bit DB on 64 bit machine

On Tue, 2010-10-26 at 18:53 -0500, Martin, Brian D. (JSC-OD)[UNITED SPACE ALLIANCE LLC] wrote: > Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and > overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good > initial starting point before performing hot standy

[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good initial starting point before performing hot standy write ahead logging (WAL) replication between a 32 bit and 64 bit machine. When I copy the 32 bit

[GENERAL] PostgreSQL 32 bit DB on 64 bit machine

Can a 32 bit PostgreSQL v. 9.0 db be copied from a 32 bit machine and overwrite the db on a 64 bit PostgreSQL machine? I'm trying to get a good initial starting point before performing hot standy write ahead logging (WAL) replication between a 32 bit and 64 bit machine. When I copy the 32 bit

Re: [GENERAL] DB become enormous with continuos insert and update

On 27 Oct 2010, at 24:22, Hfe80 wrote: > We tried everything...vacumm works. > The problem is that updates need more space becouse datas is not overwritten > in the same space... > it seems that when there is huge update db grow to create space necessary > ...700 Mb every time and than vacuum work

Re: [GENERAL] DB become enormous with continuos insert and update

We tried everything...vacumm works. The problem is that updates need more space becouse datas is not overwritten in the same space... it seems that when there is huge update db grow to create space necessary ...700 Mb every time and than vacuum works but only since next update! and db grow 700Mb m

Re: [GENERAL] DB become enormous with continuos insert and update

On 26 October 2010 22:01, Hfe80 wrote: > Some one know how to solve the problem of db that became huge from 700 Mbyte > to 16 Gbyte in 10 days and grow... > Vacuum doesn't solve the problem. > Only vacuum full is too invasive, the only way to reduce the DB  is dump and > restore, but we cannot sto

Re: [GENERAL] DB become enormous with continuos insert and update

On 10/26/10 2:01 PM, Hfe80 wrote: Some one know how to solve the problem of db that became huge from 700 Mbyte to 16 Gbyte in 10 days and grow... Vacuum doesn't solve the problem. Only vacuum full is too invasive, the only way to reduce the DB is dump and restore, but we cannot stop service...

Re: [GENERAL] DB become enormous with continuos insert and update

Hi, Il 26/10/10 23:01, Hfe80 ha scritto: Some one know how to solve the problem of db that became huge from 700 Mbyte to 16 Gbyte in 10 days and grow... Which version of PostgreSQL are you using? Some one Know this problem? Yes. Welcome to the "Bloating" club. :) Ciao, Gabriele -- Gabriele

Re: [GENERAL] DB become enormous with continuos insert and update

On Tue, 2010-10-26 at 14:01 -0700, Hfe80 wrote: > Some one know how to solve the problem of db that became huge from 700 Mbyte > to 16 Gbyte in 10 days and grow... > Vacuum doesn't solve the problem. > Only vacuum full is too invasive, the only way to reduce the DB is dump and > restore, but we ca

[GENERAL] DB become enormous with continuos insert and update

Some one know how to solve the problem of db that became huge from 700 Mbyte to 16 Gbyte in 10 days and grow... Vacuum doesn't solve the problem. Only vacuum full is too invasive, the only way to reduce the DB is dump and restore, but we cannot stop service... I know that a in a similar db where

Re: [GENERAL] Advice needed on application/database authentication/authorization/auditing model

Hey Tony, 2010/10/27 Tony Cebzanov > On 10/23/10 11:01 AM, Craig Ringer wrote: > > Yep. As for not explicitly mentioning "lower" roles when granting a > > higher role (ie "admin" isn't also a "user") - role inheritance. > > I knew about role inheritance, I just didn't know about the > pg_has_rol

Re: [GENERAL] Why Select Count(*) from table - took over 20 minutes?

On Tue, Oct 26, 2010 at 2:18 PM, Ozz Nixon wrote: > I am the only user on this system right now, and one table select count(*) > took over 20 minutes: > > wikitags exists and has 58,988,656 records. > > Structure (in pascal) is: > >   quer.SQL.Add('create table '+DBTags+' ('); >   quer.SQL.Add('

Re: [GENERAL] Advice needed on application/database authentication/authorization/auditing model

On 10/23/10 11:01 AM, Craig Ringer wrote: > Yep. As for not explicitly mentioning "lower" roles when granting a > higher role (ie "admin" isn't also a "user") - role inheritance. I knew about role inheritance, I just didn't know about the pg_has_role() function for determining if a user has a rol

Re: [GENERAL] What is better method to backup postgresql DB.

In response to Steeles : > new to postgresql. need to backup postgresql DB, which way is better to > backup DB. > > from training, I learned that we can backup the whole PGdata and other > directories to achieve backup goal, originally I was planned to schedule > jobs to use pgdump to backup all

[GENERAL] What is better method to backup postgresql DB.

new to postgresl. need to backup postgresql DB, which way is better to backup DB. from training, I learned that we can backup the whole PGdata and other direcotries to acheive backup goal, originally I was plainned to schedule jobs to use pgdump to backup all DBs. so which way is better for backu

Re: [GENERAL] Full text search in Chinese

At 11:42 AM 10/25/2010, Mike Chamberlain wrote: Has anyone implemented FTS in Chinese on PG? Â I guess I need a Chinese ispell dictionary and parser, neither of which I can find after a lot of googling. I have a bounty on this question on Stackoverflow if anyone wants to claim it:

Re: [GENERAL] Why Select Count(*) from table - took over 20 minutes?

On October 26, 2010 10:18:41 am Ozz Nixon wrote: > I have hung off indexes for each column, to resolve my previous > "performance" issue from 3+ weeks ago. However, COUNT() is still dog slow > - this table is a write once, read many... *never* update, nor delete. > > Any suggestions? If you need

Re: [GENERAL] Why Select Count(*) from table - took over 20 minutes?

On 10/26/10 10:18 AM, Ozz Nixon wrote: I am the only user on this system right now, and one table select count(*) took over 20 minutes: wikitags exists and has 58,988,656 records. Structure (in pascal) is: quer.SQL.Add('create table '+DBTags+' ('); quer.SQL.Add(' pagename '+SQL_TITL

Re: [GENERAL] Why Select Count(*) from table - took over 20 minutes?

In response to Ozz Nixon : > I am the only user on this system right now, and one table select count(*) > took over 20 minutes: > > wikitags exists and has 58,988,656 records. > > Structure (in pascal) is: > >quer.SQL.Add('create table '+DBTags+' ('); >quer.SQL.Add(' pagename '+SQL_T

[GENERAL] Why Select Count(*) from table - took over 20 minutes?

I am the only user on this system right now, and one table select count(*) took over 20 minutes: wikitags exists and has 58,988,656 records. Structure (in pascal) is: quer.SQL.Add('create table '+DBTags+' ('); quer.SQL.Add(' pagename '+SQL_TITLE+'(100) not null,'); quer.SQL.Add(' t

Re: [GENERAL] what can depend on index

On 26 October 2010 16:29, Tom Lane wrote: > Szymon Guz writes: > > today I noticed that in the documentation there is DROP INDEX CASCADE. > > I've got one question: what is that for? What can depend on index? > > Unique constraints and foreign key constraints, for starters. > > But even if there

Re: [GENERAL] what can depend on index

On 26 October 2010 16:21, David Fetter wrote: > On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote: > > Hi, > > today I noticed that in the documentation there is DROP INDEX > > CASCADE. I've got one question: what is that for? What can depend > > on index? > > A foreign key can, if the

Re: [GENERAL] what can depend on index

Szymon Guz writes: > today I noticed that in the documentation there is DROP INDEX CASCADE. > I've got one question: what is that for? What can depend on index? Unique constraints and foreign key constraints, for starters. But even if there weren't anything, we'd still provide the CASCADE syntax

Re: [GENERAL] what can depend on index

On Tue, Oct 26, 2010 at 10:13:04AM +0200, Szymon Guz wrote: > Hi, > today I noticed that in the documentation there is DROP INDEX > CASCADE. I've got one question: what is that for? What can depend > on index? A foreign key can, if the index is unique. Cheers, David. -- David Fetter http://fet

Re: [GENERAL] rule which unpredictable modify a sequence number

On Sat, Oct 23, 2010 at 9:53 AM, Armand Turpel wrote: > > I have a problem with a rule which unpredictable modify a sequence > number. When I add a new table entry, the new id_keyword hasnt the value > as expected. ex.: 1000, 1001, > 1002,.. If i remove the

Re: [GENERAL] Slow connection once the PC is network connected

On 26 Oct 2010, at 11:39, Yan Cheng CHEOK wrote: > Hello, I am deploying a database to customer PC, which will be only connected > by local application. > > However, I realize once the PC is network connected, the connection take > extremely long time (around 10 seconds) That sounds suspicious

Re: [GENERAL] Slow connection once the PC is network connected

Hello check your dns service, first. second try to use IP address instead host name Regards Pavel Stehule 2010/10/26 Yan Cheng CHEOK : > Hello, I am deploying a database to customer PC, which will be only connected > by local application. > > However, I realize once the PC is network connected

[GENERAL] Slow connection once the PC is network connected

Hello, I am deploying a database to customer PC, which will be only connected by local application. However, I realize once the PC is network connected, the connection take extremely long time (around 10 seconds) May I know why this happen? I was wondering whether is there any workaround to ov

Re: [GENERAL] How to update multiple rows

If you do not understand what you are doing, it might be a good idea to find someone in your organization who understands SQL. You were given the suggestion UPDATE SET FROM ... which is documented here: http://www.postgresql.org/docs/9.0/interactive/sql-update.html In the end, your query should

Re: [GENERAL] How to update multiple rows

Dear Alban, Thanks for your great response.I am not able to compile the query which you have given..I am not able to understand.Please alter my code. (select kasarano from parcelsdata), murabano=(select murabano from parcelsdata), the_geom = (select (st_

[GENERAL] what can depend on index

Hi, today I noticed that in the documentation there is DROP INDEX CASCADE. I've got one question: what is that for? What can depend on index? regards Szymon

Re: [GENERAL] How to update multiple rows

On 26 Oct 2010, at 9:07, venkat wrote: > Dear All, > > I want to update multiple row in single query.I am trying for below query.I > am getting error as > > "ERROR: more than one row returned by a subquery used as an expression > SQL state: 21000" You're probably looking for UPDATE table F

[GENERAL] How to update multiple rows

Dear All, I want to update multiple row in single query.I am trying for below query.I am getting error as "ERROR: more than one row returned by a subquery used as an expression SQL state: 21000" Here is my Query. update parcelsdata set gid=(select random() * 10), kasarano=(select kasar