Howdy,
Environment:
Solaris 10
Postgres 8.3.11
I'm running a dump/restore in a shell script. There are 3 machines involved.
Host1 where the shell script is being run from, host2 where the database is
being dumped from, host3 where the database is being restored to. Shell script
looks like
2010/11/29 Tom Lane
> Anderson Valadares writes:
> > I am facing problems starting the database. Following is the error
> message.
> > Can anyone help me?
>
> > 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL: XX000: failed to
> > re-find parent key in index "22723655" for split pages 37083
Doesn't look like it at the moment. I'll see if we can get that setup and
go from there. Thanks.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Monday, November 29, 2010 4:10 PM
To: Michael Holt
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Diagnosing Postgres Se
Michael Holt writes:
> Im trying to figure out what might have caused this, partly because I want
> to replicate the segfault to see if it is the cause of another system
> randomly freezing on us. Is there any way to figure out exactly what query
> being run at the time of the crash was doing?
I
Anderson Valadares writes:
> I am facing problems starting the database. Following is the error message.
> Can anyone help me?
> 2010-11-29 18:12:41 BRST [] - [5011]: [14-1] FATAL: XX000: failed to
> re-find parent key in index "22723655" for split pages 370836/370837
The only way you're going
Early this morning one of our databases suffered a segfault. The only note
on this in /var/log/messages was:
Nov 29 03:34:07 servername kernel: postmaster[18265]: segfault at
17b82000 rip 003c45e7c266 rsp 7fff2ca1b7d8 error 4
(replaced actual server name with servername)
The
Joe Carr wrote on 19.10.2010 00:55:
Hi Thomas, Thanks for your reply. pg_ctrl has given me some more
information, but I'm not quite there yet.
I have verified that the postgres user has "full control" access to
the data directory.
When I take the commandline from the service definition and exec
Hello
I am facing problems starting the database. Following is the error message.
Can anyone help me?
Parameters
synchronous_commit = off
archive_mode = on
sync = on
Postgres 8.4.5
Linux 2.6.18-194.3.1.el5 # 1 SMP Thu May 13 13:08:30 EDT 2010 x86_64 x86_64
x86_64 GNU / Linux
2010-11-29 18:12:
Joe,
I'm seeing the exact same thing when I do a fresh installation of Postgres
9.0 on either a 2008 installation or a 2003 installation. In both cases I
ensure the entire directory structure is owned by postgres and I've even
made postgres a member of the local Administrators group with the sam
Does anyone know of a module for postgres that can do metadata management in
postgres but actual storage of binary objects in filesystem ?
Not really using Postgres large object but want to just do the metadata
management with postgres. Example, need to store file
name/size/directory/drive/node
Silvio Brandani wrote:
> During a server restart the mount point /var/lib/pgsql/data lost
> the 0700 permission and the automatic restart of postgres failed.
>
> How can I set the permission of this mount point to be not lost
> during restart of server ?? Have I to set specific option in
> fs
During a server restart the mount point /var/lib/pgsql/data lost the
0700 permission and the automatic restart of postgres failed.
How can I set the permission of this mount point to be not lost during
restart of server ?? Have I to set specific option in fstab??
thanks
---
Utilizziam
> ERROR: could not set permissions on directory "C:/Program
Files/PostgreSQL/9.0/
> data/kasia": Permission denied
Well - I guess you ran into internal checks, because you tried to create
a tablespace within the cluster. Normally you'd create tablespaces on a
different partition or better disk.
Manasi Save, 29.11.2010 08:24:
I am new to postgresql. I have pgadmin installed on my windows
machine locally using which i m connecting to the client server and
accessing the database. I want to take the backup of client database.
but it seems hard the database is very large. and when i select a
Hi All,
I am new to postgresql. I have pgadmin installed on my windows machine locally
using which i m connecting to the client server and accessing the database. I
want to take the backup of client database. but it seems hard the database is
very large. and when i select any database and hit b
15 matches
Mail list logo
