On Wed, 2007-06-06 at 23:31 -0700, Jerry Huff wrote:
> I am having a problem in restoring from WAL files. I have restored
> from a dump file and trying to step through the WAL files.
> PANIC: syntax error in history file: START WAL LOCATION: 2/5DC04228
> (file 00010002005D)
Please se
On Thu, 2007-06-07 at 08:50 +0100, Simon Riggs wrote:
> On Wed, 2007-06-06 at 23:31 -0700, Jerry Huff wrote:
> > I am having a problem in restoring from WAL files. I have restored
> > from a dump file and trying to step through the WAL files.
>
> > PANIC: syntax error in history file: START WAL L
Hi All,
I was wondering if anyone has had success implementing a warm spare
database using WAL archiving on a v8.0.4 database. I know the
documentation that states warm spare was in 8.2.4 manual but having read
and re-read it, it "should" work as it is not using any v8.2-specific
feature to achie
On 6 7 , 3 51 , [EMAIL PROTECTED] (Andrew Sullivan) wrote:
> On Tue, Jun 05, 2007 at 05:28:10PM -0700, Charles.Hou wrote:
> > Client connected: about 100 pc, 1 pc with 1 connection at least, the
> > max is 4 connections
>
> So up to 400 connections? Are they all running transactions? For
> any
Look up dblink(...) function in PG documentation:
http://search.postgresql.org/search?u=%2Fdocs%2F8.2%2Fstatic%2F&q=dblink
Igor Neyman
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Raul Retamozo
Sent: Wednesday, June 06, 2007 7:09 PM
To: pgsql
"Ali, Luqman" <[EMAIL PROTECTED]> writes:
> I was wondering if anyone has had success implementing a warm spare
> database using WAL archiving on a v8.0.4 database. I know the
> documentation that states warm spare was in 8.2.4 manual but having read
> and re-read it, it "should" work as it is not
Chris Hoover wrote:
Maybe I'm blind (wouldn't be the first time), but I can't see a way to find
out how long postgres has been running. Is there a way to tell this from a
query? I am working with some of the stat views and would like to
correlate
them to how long the server has been running.
Abraham, Danny wrote:
Hi,
I am migrating from Sybase to Postgres.
trying to get a hold on the issue of future releases feature list.
1. Where can I find the feature list for 8.3 ? When is it expected?
The roadmap currently shows 8.3 releasing sometime this summer. At this
time, you should
On Thu, Jun 07, 2007 at 12:07:03AM -0700, Charles.Hou wrote:
> i use the VACUUM VERBOSE a table , but it had been hold 10 minutes . i
> must use the linux command " kill " to exit the VACUUM.
> after i kill this PID, the PostgreSql have been restart
> automatically.
Maybe it was doing work. Why d
On Wed, Jun 06, 2007 at 04:04:44PM -0600, Dan Harris wrote:
> of these operations or a full dump/reload. I do run VACUUM regularly, it's
> just that sometimes we need to go back and update a huge percentage of rows
> in a single batch due to changing customer requirements, leaving us with
> sig
On Sat, 2007-06-02 at 01:07 +0100, Jon Colverson wrote:
> Simon Riggs wrote:
> > I've spent some time re-examining the code and I can't see a route for
> > the discussed problem to occur. All the main code paths do not exhibit
> > this problem in 8.2, so I'm not sure where to go from here.
> >
> >
Andrew Sullivan wrote:
On Wed, Jun 06, 2007 at 04:04:44PM -0600, Dan Harris wrote:
of these operations or a full dump/reload. I do run VACUUM regularly, it's
just that sometimes we need to go back and update a huge percentage of rows
in a single batch due to changing customer requirements, lea
Hello People,
Mac OS 10.3.9
PostgreSQL 8.0
Background: I was reading a book titled Mac OS X Hacks,
which has a brief
section on installing PostgreSQL. It suggested one start by
installing Fink,
which I successfully did. Then I used FinkCommander to
install PostgreSQL
8.0, which seemed to be succe
On Jun 7, 2007, at 8:12 PM, [EMAIL PROTECTED] wrote:
Can anyone please tell me where I can get some info. to
figure out what I need
to do to set up a) my server, b) my Postgres user, c) the
PostgreSQL
configurations?
The easiest way to determine if PostgreSQL is running is to use
Activity
[EMAIL PROTECTED] writes:
> Background: I was reading a book titled Mac OS X Hacks, which has a
> brief section on installing PostgreSQL. It suggested one start by
> installing Fink, which I successfully did. Then I used FinkCommander
> to install PostgreSQL 8.0, which seemed to be successful (it r
Hi,
Whenever I am starting the Database Service of Postgres the cursor is
halting at "Database System Is Ready".
It should come to the prompt so that I can start executing the commands.
But when I stop the service the cursor is halting at the Prompt. Which
is correct.
This is happening in Li
Try to start with following command
pg_ctl start -l logfile
Lets see will it help...
With Regards
Ashish...
- Original Message -
From: Khan, Mahmood Ahram
To: [EMAIL PROTECTED] ; pgsql-admin@postgresql.org ; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: F
You can try running the service in background . using '&' in linux
environment.
From: "Khan, Mahmood Ahram" <[EMAIL PROTECTED]>
To:
<[EMAIL PROTECTED]>,,<[EMAIL PROTECTED]>
CC: <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]>
Subject: Regarding Database Service Start
Date: Fri, 8 Jun 2007 10:01:53 +0
18 matches
Mail list logo
