The following bug has been logged online:
Bug reference: 5933
Logged by: rajesh
Email address: sri_rajesh_...@yahoo.co.in
PostgreSQL version: 8.3
Operating system: linux
Description:database restore error
Details:
my postgresql services could not start that's why i
Hi Kevin!
Thanks for your reply. You make me feel that this is more serious than I
thought.
This is development server, that is also used as pre-live server.
Pre-live database is restored from live database dump every night. So
far the errors have been in pre-live database, that's why I didn
Tambet Matiisen wrote:
> Pre-live database is restored from live database dump every night.
How is that done? A single pg_dump of the entire live database
restored using psql? Are both database servers at the same
PostgreSQL version?
> So far the errors have been in pre-live database,
Yo
"rajesh" wrote:
> replace the old data folder
> FATAL: could not open file "base/16519/PG_VERSION": Permission
> denied
> Previous connection kept
What user is running the postgres process? Who owns the
"base/16519/PG_VERSION" file and its ancestor directories?
-Kevin
--
Sent via pgsql
On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer wrote:
> I'm working on a hypercube implementation in Postgres using contrib/cube
>
> and need to insert 80,000 rows in one go from Python. Doing so with
> INSERT, even multiple statements in one call, is pretty slow. I've been
> investigating if usin
The following bug has been logged online:
Bug reference: 5934
Logged by: Frederic Junod
Email address: frederic.ju...@camptocamp.com
PostgreSQL version: 8.4
Operating system: debian squeeze
Description:postgresql.conf: optional equal sign
Details:
Hello,
According
bricklen wrote:
> On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer
> wrote:
> > I'm working on a hypercube implementation in Postgres using
> contrib/cube
> >
> > and need to insert 80,000 rows in one go from Python. Doing so with
> > INSERT, even multiple statements in one call, is pretty slow. I'v
Tambet Matiisen wrote:
> On 16.03.2011 17:09, Kevin Grittner wrote:
>> Tambet Matiisen wrote:
>>
>>> Pre-live database is restored from live database dump every
>>> night.
>>
>> How is that done? A single pg_dump of the entire live database
>> restored using psql? Are both database servers at t
Em 16-03-2011 12:25, Frederic Junod escreveu:
"Error: Invalid line 502 in /etc/postgresql/8.4/main/postgresql.conf:
»listen_addresses '*'«"
AFAICS it is a Debian bug not a PostgreSQL one. I already hit it once but
didn't investigate the problem. [looking at debian bugs...] It seems you
alread
