Thanks for the reply. we will be reviewing the settings soon.
Also have manually ran the database-wide vacuum on the 50GB database . (for safety reasons). the transaction count is 1147399191. we plan to automate this process once a month or so.
Do we need to Disable the Auto-vacuum deamon when
Its working fine now.
Thanks a lot.
Dhanesh Prabha P.V | WIPRO Technologies | Bangalore
+91-80-25056768 | (+91) 9986335390 | Voice Net: 805-4736
-Original Message-
From: Jason Minion [mailto:[EMAIL PROTECTED]
Sent: Monday, April 24, 2006 6:52 PM
To: Dhanesh Prabha (WT01 - CIO OFFICE &
Hi
Iam Srinivas ,iam
new to postgreSQL I installed without any problem but iam unable to start to
start service
plse help me
how to startservice
Thanks and
regards
Srinivas
Please reply to the list so that others can help (and so I don't have to reply
using Outlook ;)
There should be some menu options under Start/PostgreSQL 8.1 for starting and
stoping PostgreSQL.
-Original Message-
From: D Srinivas-in1713c [mailto:[EMAIL PROTECTED]
Sent: Mon 4/24/2006 11:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Bruno Cortes wrote:
>> This was even worse than the previous error. Right now I cannot enter
>> the database neither make a dump. When I execute a command such as "psql
>> -U postgres center-01" I get the error:
>> psql: FATAL: catalog is missing 10 a
Jim C. Nasby wrote:
> On Mon, Apr 24, 2006 at 03:06:03PM -0400, Alvaro Herrera wrote:
> > > Also, maybe that should be defined in one place rather than duplicating
> > > it in autovacuum.c?
> >
> > Hmm ... do you care enough to send a patch?
>
> I'm always up for a challenge... :)
>
> Where shou
On Mon, Apr 24, 2006 at 03:06:03PM -0400, Alvaro Herrera wrote:
> > Also, maybe that should be defined in one place rather than duplicating
> > it in autovacuum.c?
>
> Hmm ... do you care enough to send a patch?
I'm always up for a challenge... :)
Where should I go about defining it? Better yet,
On Mon, Apr 24, 2006 at 08:43:26AM -0400, Alvaro Herrera wrote:
> Bruno Cortes wrote:
> > Hi,
> >
> > I was trying to make a dump from a database in postgresql 7.4.2-1. I was
> > enable to do so because of a cache lookup problem.
> > To solve it, I enter the database as superuser and execute VACU
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Jim C. Nasby wrote:
>> Ok, I'll bite... any idea how (MaxTransactionId >> 3) * 3 was chosen? I
>> don't see anything about it in vacuum.c...
> I don't remember exactly why was that constant chosen. IIRC Tom pulled
> it out of thin air.
Pretty much. O
Hi all,
I tried to "move" the /data folder to another HD. The service refuse
to start after that and does not raise any errors.
- Stop service
- Copy /Program Files/PostgreSQl/8.1/data folder to, let say, d:/data
- Changed /Program Files/PostgreSQl/8.1/data/postgresql.conf:
data_directory = 'd:/d
On Mon, Apr 24, 2006 at 10:18:47 -0400,
Manish Gupta <[EMAIL PROTECTED]> wrote:
> Hello Tom,
>
> I have filed a bug (# 189764) with fedoraproject.
>
> I tried with unix sockets with same results. So, for the time being
> disabling SELinux seems to be the only solution.
You are usually better
Jim C. Nasby wrote:
> On Mon, Apr 24, 2006 at 08:41:55AM -0400, Alvaro Herrera wrote:
> > The test for database-wide vacuum is:
> >
> > database age > big_constant
> >
> > where:
> >
> > big_constant = (MaxTransactionId >> 3) * 3 - 10) = 1610512733
>
> Ok, I'll bite... any idea how (MaxTran
Hi,
I'm having problems trying to make a full backup of a database.
I search in many places but I can't find where is te mistake of my
procedure.
I'm running this command:
$ pg_dump -C -F P -o -h db1 -U postgres MAINDB > backup1
But I can't make pg_dump to backup all the sequences in the DB,
On Mon, Apr 24, 2006 at 08:41:55AM -0400, Alvaro Herrera wrote:
> The test for database-wide vacuum is:
>
> database age > big_constant
>
> where:
>
> big_constant = (MaxTransactionId >> 3) * 3 - 10) = 1610512733
Ok, I'll bite... any idea how (MaxTransactionId >> 3) * 3 was chosen? I
don't
On Mon, Apr 24, 2006 at 11:21:16AM +0530, Gourish Singbal wrote:
> The Age of the database is 1144759836 . We have enabled autovacuuming .
> The details are:-
> autovacuum = on
> autovacuum_naptime = 300
> autovacuum_vacuum_threshold = 1
> autovacuum_analyze_threshold = 5000
> autovacuum_vacuum
Ok, so why does that require row-by-row processing?
On Thu, Apr 20, 2006 at 08:45:57PM -0700, Sriram Dandapani wrote:
> Yes..all of it is in one transaction as there is a window of record ids
> that need to be processed in 1 transaction. Data inflow is very
> voluminous appx 1 million every 15 min
Show autovacuum displays 'on'.
db1=# select datname, datvacuumxid, datfrozenxid from pg_database; datname | datvacuumxid | datfrozenxid-+--+-- postgres | 499 | 499
db1 | 71677296 | 3292902769 d
have you tried using double quotes on your command instead of that single quote...
ex. psql -c "insert into table values('a', 'b')"On 4/19/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Hi
,
I
am trying to insert data into the table via shell script using psql
command.
But it giv
Hello Tom,
I have filed a bug (# 189764) with fedoraproject.
I tried with unix sockets with same results. So, for the time being
disabling SELinux seems to be the only solution.
Thanks for all the help.
Manish
"Manish Gupta" <[EMAIL PROTECTED]> writes:
> I was able to solve this issue by
Bruno Cortes wrote:
> Hi,
>
> I was trying to make a dump from a database in postgresql 7.4.2-1. I was
> enable to do so because of a cache lookup problem.
> To solve it, I enter the database as superuser and execute VACUUM ALL.
> This was even worse than the previous error. Right now I cannot e
On Wed, Apr 19, 2006 at 01:51:59AM -0700, [EMAIL PROTECTED] wrote:
> what is the procedure for creating a "hot standby" (continuously
> feeding
> a series of WAL files created by the primary machine into the
> secondary
> one) ?
Take a look at http://pgfoundry.org/projects/pgpitrha/ ; it should
The postgresql-8.1.3-1.zip link on
http://www.postgresql.org/ftp/binary/v8.1.3/win32/ will get you a binary
installer for windows, which should be all you need to get started. Just
unzip it somewhere and double-click on postgresql-8.1.msi (not
postgresql-8.1-int.msi).
PostgreSQL supports most popu
You're using single quotes inside single quotes, you'll need to either
escape them or switch to double-quotes for your outer string delimiter
(preferred). ie:
/usr/local/pgsql/bin/psql -d temp -c "insert into temp.ip_mapping_tb(ip,
location) values('192.100.9.51','First Floor')"
Jason Minion
[
Gourish Singbal wrote:
> The Age of the database is 1144759836 . We have enabled autovacuuming .
> The details are:-
> autovacuum = on
Are you sure autovacuum is enabled? Do a "SHOW autovacuum" just to be
sure.
The test for database-wide vacuum is:
database age > big_constant
where:
big_const
Your problem here is quoting. You need to escape the quotes around the
SQL strings so that the shell (I assume you're using Unix of some
flavour) doesn't interpret them:
/usr/local/pgsql/bin/psql -d temp -c 'insert into
temp.ip_mapping_tb(ip,location) values(\'192.100.9.51\',\'FirstFlo
hello,
I am trying to setup a "hot standby" on a second machine.
I have created a "recovery.conf" file and started a restore with logs
from the primary machine. everything was OK.
now a have new transaction logs generated by the primary machine and I
want to "play" them on the secondary one. I
Hi,
I was trying to make a dump from a database in postgresql 7.4.2-1. I was
enable to do so because of a cache lookup problem.
To solve it, I enter the database as superuser and execute VACUUM ALL.
This was even worse than the previous error. Right now I cannot enter
the database neither make
I am trying to add
the -w option to the Windows NT service startup so that the service is really
running before it returns (I have another service - tomcat - that depends on
it). I can add the -w, but when I try to start the postgresql service, I
get an error about the service starting then
Hello:I need help with installationI'm working on a XP Pro box, and trrying to install postgresql 8.1.3 from windows installer. I always installed previous versions without a problem, but recently I've made some changes to user permissions, and now I´m getting this error message:"failed to create p
Hi
,
I
am trying to insert data into the table via shell script using psql
command.
But it giving syntax error. the same query is finely working pgAdmin III
client.
The query and error given below.
Eg:
/usr/local/pgsql/bin/psql -d temp -c 'insert into
temp.ip
Hi All,
I get this error when I try to connect a web application running on
tomcat, to a postgreesql database.
Below is the data from tomcat logs--
---
com.rapidigm.bacs.db.BacsDBException: (executing StatementCallback):
encountered
SQLException [ERROR: No parser with id 17555]; nested exce
HI
This is srinivas I
want install postgresql8.1 on windows XP, would u plse send step by step
installation process,
what is the driver
it can be support.
thanks in
advance
Regards.
Srinivas
32 matches
Mail list logo
