pavankumar reddy wrote:
> working on postgresql 8.1.4
You need to at least get onto an 8.1 revision which is more recent.
You're missing over four years of bug fixes.
http://www.postgresql.org/support/versioning
http://www.postgresql.org/docs/8.1/static/release.html
> 1)IAM UNABLE TO TA
HELLO ,
This is pavankumar , working on postgresql 8.1.4, database, for
which iam new and very less in knowledge. Iam not an expert.
please help me in resolving the problem which iam facing since one week.the
problem is
1)IAM UNABLE TO TAKE A COMPLETE BACKUP OF DATABASE
2)IAM UNABLE T
Dear friends,
At last i can solved the problem by running CHKDSK. This program found
bad allocation unit on pg_clog folder. After repairing, service can
start again.
Thank you for your advice. I really appreciate it.
Regards,
Hengky
On Nov 4, 2009, at 2:14 AM, Scott Marlowe wrote:
On T
On Tue, Nov 3, 2009 at 12:41 AM, Hengky Lie wrote:
> What exactly file pg_clog/0085 exactly is ? Thank you for any advice. Now
> i'm trying to check file permission and antivirus.
>
pg_clog contains the commit log. Once things in pg_xlog have been committed
to disk when the background writer get
--- On Tue, 3/11/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [ADMIN] Please Help... Service fails to start
To: "Hengky Lie"
Cc: pgsql-admin@postgresql.org
Date: Tuesday, 3 November, 2009, 3:37 AM
Hengky Lie writes:
> 2009-11-02 10:13:35 FATAL: could not access status of tr
uch the file and restart the database. However,
in this case you will be lose your data.
-- Thanks
Sam Jas
--- On Tue, 3/11/09, Tom Lane wrote:
From: Tom Lane
Subject: Re: [ADMIN] Please Help... Service fails to start
To: "Hengky Lie"
Cc: pgsql-admin@postgresql.org
Date: Tuesd
Hengky Lie writes:
> 2009-11-02 10:13:35 FATAL: could not access status of transaction
> 139856778
> 2009-11-02 10:13:35 DETAIL: Could not read from file "pg_clog/0085"
> at offset 98304: Permission denied.
You need to fix that "Permission denied" problem. Either the file
really is marked
Dear Friends,
I really need help for my problem, 7 days ago Postgresql service fails
to start and i have no backup ! (OS: Windows XP Pro). I tried googling
everywhere but didn't find any solution.
I had tried to start the service manually from control panel, it
started for about 5 seconds
"Kevin Grittner" writes:
> TRAN THI NGOC MAI wrote:
>> 2009-07-26 11:58:49,037 ERROR service.ReliableFileTransferImpl
>> [main,:68] Unable to setup database driver with
>> pooling.Backend start-up failed: FATAL: database "rftDatabase", OID
>> 17142, has disappeared from pg_database
> If not,
TRAN THI NGOC MAI wrote:
> Stopping postgresql service: [ OK ]
> Starting postgresql service: [ OK ]
So it appears that PostgreSQL is working OK. Right?
> 2009-07-26 11:58:49,037 ERROR service.ReliableFileTransferImpl
> [main
Please, help me!
I install postgresql to configuring RFT. But when I start postgresql and start
globus container, I get error in the log file
Here is the result when I type command:
--
[r...@linux01 globus]# /etc/init.d/postgresql restart
Stopping postgresql service:
On 10/22/07, Anibal David Acosta <[EMAIL PROTECTED]> wrote:
>
> Really all file content after object definitions looks like
> "Encoded/Encrypted" and when I do a restore all table data are restored
> successfully (except one, that is in the "corrupted sector"). So, maybe the
> pg_dump do a encrypt
of the corrupt data…
-Original
Message-
From: Anibal David
Acosta
[mailto:[EMAIL PROTECTED]]
Sent: Monday, 22
October 2007
15:33
To: Phillip Smith
Subject: Re: [ADMIN]
Please help
(backup)
I open with word pad
&
notepad, but table, functions and other object declarations looks like
&
Acosta [mailto:[EMAIL PROTECTED]
Sent: Monday, 22 October 2007 15:33
To: Phillip Smith
Subject: Re: [ADMIN] Please help (backup)
I open with word pad & notepad, but table, functions and other object
declarations looks like "plain text" but the DATA nope.
This is the beginnig of
] [mailto:pgsql-admin-
> [EMAIL PROTECTED] On Behalf Of Anibal David Acosta
> Sent: Monday, 22 October 2007 11:16
> To: pgsql-admin@postgresql.org
> Subject: [ADMIN] Please help (backup)
>
> I have a backup done with "pg_dump" utility.
>
> For some reason th
I have a backup done with "pg_dump" utility.
For some reason the backup file has 8 phisical bad sectors (17 KB of data)
Now when I try to restore the backup all tables are created successfully
and data of almost all tables restores successfully too, but one table
(the most important) appear em
You can unsubscribe here
http://www.postgresql.org/community/lists/subscribe
On 11/1/07 14:05, in article [EMAIL PROTECTED],
""raphael ferrer"" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I would like to stop receive emails from pg forum.
>
> How could i do that?
>
> Thanks
>
> ___
Hello,
I would like to stop receive emails from pg forum.
How could i do that?
Thanks
_
Die MSN Homepage liefert Ihnen alle Infos zu Ihren Lieblingsthemen.
http://ch.msn.com/
---(end of broadcast)--
I try to restore a backup, but I got the following error:
pg_restore: [custom archiver] could not read data block -- expected
4096, got 2353
I run
pg_ctl (PostgreSQL) 8.0.3
I've tried the same with different backups ( one day before or after ) ,
and I tried also with -i flag ( ignore version )
Hi, With this i enclosed my requirement. Along with this i would like to know your suggestion and the way to impliment the same as a service. Please note that i am using PGSQL 8.0 no-installer in Windows. One of the member had came up with the suggestion that it is related to Windows impersonal
Sir/Madam
i need to take back up (dump file) using sql command.
i am using vb as front end. So i need to take the back
up using front end. so i need the sql command. I need
the same command for restore also. Please help me.
__
Do You Yahoo!?
Tired o
08, 2005 10:17 PM
To: Alvaro Herrera
Cc: Pradeepkumar, Pyatalo (IE10); pgsql-admin@postgresql.org;
[EMAIL PROTECTED]
Subject: Re: [ADMIN] Please help - libpq API
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Sep 07, 2005 at 11:40:57PM -0700, Pradeepkumar, Pyatalo (IE10)
wrote:
&
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Wed, Sep 07, 2005 at 11:40:57PM -0700, Pradeepkumar, Pyatalo (IE10) wrote:
>> Even if somehow if I convert wchar_t * to char * and provide it to
>> Postgres, how will it differentiate between chinese characters and normal
>> characters ??
> Please n
On Wed, Sep 07, 2005 at 11:40:57PM -0700, Pradeepkumar, Pyatalo (IE10) wrote:
> I have already posted my query regarding libpq functions and wide character
> support. Pls somebody help me. I am using libpq API functions in my C code
> to do operations on the database. But the problem I m facing is
Hi,
I think that this is the wrong list for your problem. My suggestions:
contact pgsql-hackers or check the lists in the postgresql.org page, you will prolly find one list to suit with this.
or
irc.freenode.net, join #postgresql . Good boys lurking there, you will
have to fight, but help will be
Title: Please help - libpq API
Hi all,
I have already posted my query regarding libpq functions and wide character support. Pls somebody help me. I am using libpq API functions in my C code to do operations on the database. But the problem I m facing is API functions like PQexec() etcac
On Mon, Nov 15, 2004 at 10:15:30AM +0530, [EMAIL PROTECTED] wrote:
> Hi, Im migrating our database from MSSQL7.0 to postgresql on
> Solaris 9(sparc).But we have got problem in compiling the source
> code of postgresql on solaris.Can we have precompiled package of
> postgresql stable version for so
Hi, Im migrating our database from MSSQL7.0 to postgresql on Solaris
9(sparc).But we have got problem in compiling the source code of postgresql on
solaris.Can we have precompiled package of postgresql stable version for
solaris9 sparc plateform.
Its urgent, please help us.
Jagbir Singh
"The C
(B
(B
(BDear Sir,
(BI need your help. I am
(Bnew to postgresql 7.3.2 . My requirement is row level
(Bincermental backup with image & movies (datatype
(Bbytea). Ex: I have tables say sports,music,film. In
(Ball those tables I have test data aswell as bytea data(image &
(Bmovie).
To all,
I want to ask some questions:
1. I want to changes the posisions of postgres super user with my user, so
my user have a function same with postgres super user
(I want only one super user in my database).
so if i do it, what happens on my database...??
2.How i now total
First, make sure your running on a version of 7.3, then check out the
following docs:
http://techdocs.postgresql.org/guides/SetReturningFunctions
http://www.gtsm.com/cgi/psearch?page=plpgsql.html;q=plpgsql;j=0;c=0;h=0
Robert Treat
On Fri, 2003-05-30 at 00:08, utomo restu wrote:
>
> Dear All
>
Dear All
I'am a new user in postgresql, i want to ask about :
1. The one who is intended with STORED PROCEDURE,
how its implement and what its surplus.
Version POSTGRESQL that how much possess STRORED PROCEDURE.
2. In when I make the function as follows:
CREATE FUNCTION forward(
On Monday February 17 2003 4:31, Mona Gamboa wrote:
> ok...here's the output.[kinda nasty to read]
Nothing obvious to me. If it is reproduceable, you might try turning
on some of the lock tracing directives in postgresql.conf and/or
increasing the logging level. You might also try attaching to
]>
To: "Mona Gamboa" <[EMAIL PROTECTED]>
Sent: Monday, February 17, 2003 4:00 PM
Subject: Re: [ADMIN] please help--database just locks up.
Can you post the output of these commands?
uname -a
export PGDATA=/path/to/your/data
grep ^log_ $PGDATA/postgresql.conf
cat $PGDATA/postmaster
we are running linux and postgres7.3.2 in a
production environment.
the database just 'locks ups.' if i try to
get into psql X [where X is my database or template 0 or template 1] it
just sits there.
the log files don't say anything..there's
no indication as to what is happening.
Hi Folks
I am trying to write a function that should archive old values to an
archiving table before update on the orignal table but it inserts both old
and new values to the archiving table here is the code:
CREATE FUNCTION fn_archive_01() RETURNS OPAQUE AS '
BEGIN
/* TG_OP is the
On Tue, 11 Dec 2001 23:54:45 +1100 (EST)
Mr OCP <[EMAIL PROTECTED]> wrote:
> Hi
>
> We have a table like follows:
>
> id, account_name, amount, action_type
>
> The amount field has both debit and credit entires and
> action_type defines the type of transaction ( debit or
> credit), debit entr
Hi
We have a table like follows:
id, account_name, amount, action_type
The amount field has both debit and credit entires and
action_type defines the type of transaction ( debit or
credit), debit entries have negative '-' symbol before
the amount.
where there are multipble transaction for the
Hi Mike,
> Can anyone help me write a trigger on a table, I have
> created an audit table for a table and what I want
> trigger to do is to whenever a record is deleted from
> the table it should first be inserted into the audit
> table, just to keep track of whatever records are
> deleted.
Is t
Hi
Can anyone help me write a trigger on a table, I have
created an audit table for a table and what I want
trigger to do is to whenever a record is deleted from
the table it should first be inserted into the audit
table, just to keep track of whatever records are
deleted.
Thanks so much for you
Sorry, my bad. I thought your whole point was in regards to the sleep command (which I
really didn't understand why). However, your point about stressing the server is a
very valid point, and I did not catch that in your earlier post.
My apologies for the misunderstanding...
--brett
p.s. it's
Brett,
It appears that I may have upset you somehow. I didn't intend to. I
chose to write the PERL script to place them in a transaction to help
improve performance a little bit on each pass. By building and tearing
down a connection to the postmaster everytime you send an update, you will
b
This is why I said this:
> > adjust the sleep to your own specs.
If he wants to "batch" them, then all he needs to do is add a condition/count:
#!/bin/sh
cnt=1
while read line; do
# "batches" of 20 or whatever you *want*
if [ "X$cnt" == "X20" ];
Much too quick and dirty. With 300,000 updates this will take 1.5million
seconds, roughly 200 days. Even at a rate of 1 a second it will take
nearly four days. All this aside, I would probably use a perl script and
do batches of about 10-20, with a sleep. You can try something like the
followi
Mr OCP writes:
> We have about 300,000 records to update, I have created a file with
> the ids of the records to be updated, since the number of records to
> be updated is very large, the update statement takes forever and
> server slows down dramatically, therefore I want to do one at a time.
T
On Thu, 18 Oct 2001, [iso-8859-1] Mr OCP wrote:
> Hi Folks
>
> We have about 300,000 records to update, I have
> created a file with the ids of the records to be
> updated, since the number of records to be updated is
> very large, the update statement takes forever and
> server slows down dramat
A quick and dirty solution would be something like (untested):
while read line; do
psql dbname -c "update table ... use 'line' as your id and data"
sleep 5
done < filename
where "filename" is the file with the ids in it. "dbname" is the name of your DB (of
course!)
I am not su
Hi Folks
We have about 300,000 records to update, I have
created a file with the ids of the records to be
updated, since the number of records to be updated is
very large, the update statement takes forever and
server slows down dramatically, therefore I want to do
one at a time.
Do you guys hav
Do you plan to use http for your service ?
If so, I'd recommend to use following architecture:
FE - proxy server is serving incoming requests and provides
results to client. It could be very light http server with proxy support.
BE - cgi-backend which receive proxied requests, contact with databa
I have to provide a hardware-software configuration based on a PG
database,
capable to support min 500 simultaneous users each one accesing pages
that
send an average 6 queries per page. Minimum display time of any page = 5
second.
I have no precise idea about how such a configuration will be.
Dear Sir,
I am waheed from dubai.
I got your mailid, when i am searching for a document
in postgresql.And your document helped me
alot and i some more doubts i hope you can help me.
This is my problem.
I am having a table called FRUITS which will be
updated by the merchants frequently as
the me
akacker writes:
> I tried adding the following lines to pg_hba.conf file :
>
> host all 64.65.7.145 255.255.255.255 password pgpass
>
> I created pgpass by the command pg_passwd pgpass and added
> the user (i.e my client username and password) but it did not
> work.
Define "did not work".
th
Dear SirHello!I have a Linux web server on
which I am providing name based hosting services to my clients.I want
that my clients who have their virtual sites on my server shouldbe able to
connect to their databases by using php or any other server side programs to
connect to postgresql dat
Hello all,
I'm using PostGre 6.3 on a Linux box and connecting to it via Insight's ODBC
6.40.0004 driver from Win98. However, I don't think my problem lies with PG 6.3
or the ODBC driver, I think my problem is my lack of understanding on how to
correctly setup passwords.
I've searched through th
I have a database running fine, however, it is purely stock configuration. I
would like to fine tune it for better performance and to control memory
usage.
I have seen people refer to restricting the number of back end processes,
and fine tuning maximum memory consumption as well as other items.
55 matches
Mail list logo
