On Wed, Jun 25, 2014 at 5:37 AM, ChoonSoo Park wrote:
> 30022 & 30023 are symbolic links under data/pg_tblspc folder. Their target
> directories are lost somehow. Does it cause this problem? I tried to delete
> those 2 symbolic links but postgresql still can't start up.
>
Just wonder what is caus
Hi,
>From the pg_log folder, I can locate the following errors:
LOG: database system was interrupted while in recovery at log time
2014-06-06 22:35:38 UTC
HINT: If this has occurred more than once some data might be corrupted and
you might need to choose an earlier recovery target.
LOG: could
Sam Wun writes:
> I had been running postgresql 8.3.7 in freebsd for some time, but
> after I changed its postgresql.conf file, it can't start any more
> eventhoguh I changed the config back to its original file.
> Anything wrong?
> Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not cre
Hi,
I had been running postgresql 8.3.7 in freebsd for some time, but
after I changed its postgresql.conf file, it can't start any more
eventhoguh I changed the config back to its original file.
Anything wrong?
Here is the errros:
Jun 26 15:58:52 twp1 postgres[1394]: [1-1] FATAL: could not crea
I copied the sample config file to postgresql workign directory before
trying to start postgresql:
# pwd
/usr/local/share/postgresql
twp1:postgresql # cp postgresql.conf.sample ../../pgsql/data/postgresql.conf
On Fri, Jun 26, 2009 at 4:04 PM, Sam Wun wrote:
> Hi,
>
> I had been running postgresql
Igor Shevchenko <[EMAIL PROTECTED]> writes:
> I've got a problem w/ one of pgsql installations. It can't start:
> [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
> PANIC: failed to re-find parent key in "23724"
> Aborted
Try applying this patch:
http://archives.postgresql.org/pg
On Tuesday 14 November 2006 17:21, Enrico wrote:
> > Thanks, but this is not working -
> >
> > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
> > The files belonging to this database system will be owned by user
> > "postgres". This user must also own the server process.
> >
> > The
On Wednesday 15 November 2006 01:41, you wrote:
> On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
> >> I'd think starting a standalone backend and issuing a "reindex database"
> >> should be enough to get him started. Now, the problem is figuring _how_
> >> the index got in that state;
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
>> I'd think starting a standalone backend and issuing a "reindex database"
>> should be enough to get him started. Now, the problem is figuring _how_
>> the index got in that state; or even _what_ index is the problematic
>> one. (I th
On Tuesday 14 November 2006 17:34, Alvaro Herrera wrote:
> [EMAIL PROTECTED] wrote:
> > He's just trying to do what you told him.
> > But the use of initdb won't correct the problem Igor got. There's
> > something
> >
> > wrong with his database so that he can't start the postmaster process:
> > >
Hi Merlin,
On Tuesday 14 November 2006 17:36, you wrote:
> On 11/13/06, Igor Shevchenko <[EMAIL PROTECTED]> wrote:
> > I've got a problem w/ one of pgsql installations. It can't start:
> >
> > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
> > PANIC: failed to re-find parent key
On 11/13/06, Igor Shevchenko <[EMAIL PROTECTED]> wrote:
Hi All,
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in "23724"
Aborted
This is PostgreSQL 8.1.5 compiled from sour
#x27;t have any idea how to solve this issue :(
-- Matthias
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Enrico
> Sent: Tuesday, November 14, 2006 4:22 PM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] can't
On Tuesday 14 November 2006 10:52, Enrico wrote:
> Try with:
> > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Thanks, but this is not working -
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
The files belonging to this database system will be owned by user "postg
[EMAIL PROTECTED] wrote:
> He's just trying to do what you told him.
> But the use of initdb won't correct the problem Igor got. There's something
> wrong with his database so that he can't start the postmaster process:
> > PANIC: failed to re-find parent key in "23724"
>
> Unfortunately i don't
> Thanks, but this is not working -
>
> [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> in
On Tue, 14 Nov 2006 02:23:39 +0200
Igor Shevchenko <[EMAIL PROTECTED]> wrote:
Try with:
> [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Bye Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-billionaire by now ...oh look, he already is
[
Hi All,
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in "23724"
Aborted
This is PostgreSQL 8.1.5 compiled from sources, on Fedora Core4. Originally it
was 8.1.2, and the bu
Thank you all
Deleting the old data base cleared up the problem.
Ian
On Thu, 2006-07-27 at 15:59 -0500, Bruno Wolff III wrote:
On Thu, Jul 27, 2006 at 10:22:33 -0600,
Ian Johnson <[EMAIL PROTECTED]> wrote:
>
> I want to develop an application in PostgreSQL but when starting the
> serv
On Thu, Jul 27, 2006 at 10:22:33 -0600,
Ian Johnson <[EMAIL PROTECTED]> wrote:
>
> I want to develop an application in PostgreSQL but when starting the
> service I get the following message:
>
> An old version of the database format was found.
> You need to upgrade the data format before using
It seems you were running a pre-8.x postgresql version before, its
data files are not compatible with the new version you have now.
You'll need to find out the version that used to be installed by
looking at the PG_VERSION file in your postgres data directory.
Once you do that you will need
Ian Johnson wrote:
Hi List
I want to develop an application in PostgreSQL but when starting the
service I get the following message:
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See /usr/share/doc/postgresql-8.1.4/README.rpm-dist
Hi List
I want to develop an application in PostgreSQL but when starting the service I get the following message:
An old version of the database format was found.
You need to upgrade the data format before using PostgreSQL.
See /usr/share/doc/postgresql-8.1.4/README.rpm-dist for more informat
Lonni J Friedman wrote:
selinux-policy-targeted-1.17.30-2.85
up2date insists that these packages are all up to date.
And you're certain that you're using the targetted policy and not strict?
To be frank, I am not. I have not the slightest idea what all that
selinux is about (beside security in ge
Hi Tom,
sudo /sbin/restorecon -R /var/lib/pgsql
worked like a charm!
Thank you very much!
Ulrich
--
Ulrich Wisser
RELEVANT TRAFFIC SWEDEN AB, Riddarg 17A, SE-114 57 Sthlm, Sweden
Direct (+46)86789755 || Cell (+46)704467893 || Fax (+46)86789769
__
Tom Lane wrote:
One problem is that selinux-policy-targeted updates don't necessarily
propagate to the security labels of the individual files.
Sounds like it might be a good idea to add a trigger to the PostgreSQL
RPM to run restorecon when the SELinux policy is updated.
--
===
Ulrich Wisser <[EMAIL PROTECTED]> writes:
> it seems selinix doesn't like postgres. Can I uninstall selinux from
> fedora savely? OR is there any way to make them both work together?
They should work together as long as you have the latest PG RPMs (which
it seems you do) and a reasonably recent s
Ulrich Wisser wrote:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VERSION dev=dm-1
ino=1255016 scontext=user_u:system_r:postgresql_t
tcontext=root:object_r:var_lib_t tclass=file
Try running 'restorecon -n -R -v /var
On Wed, 09 Mar 2005 14:38:06 +0100, Ulrich Wisser
<[EMAIL PROTECTED]> wrote:
> Sorry,
>
> of course I forgot to mention my installed version. Please find them below:
>
> postgresql-jdbc-7.4.7-3.FC3.1
> postgresql-odbc-7.3-8.FC3.1
> postgresql-test-7.4.7-3.FC3.1
> postgresql-devel-7.4.7-3.FC3.1
>
Sorry,
of course I forgot to mention my installed version. Please find them below:
postgresql-jdbc-7.4.7-3.FC3.1
postgresql-odbc-7.3-8.FC3.1
postgresql-test-7.4.7-3.FC3.1
postgresql-devel-7.4.7-3.FC3.1
postgresql-contrib-7.4.7-3.FC3.1
postgresql-python-7.4.7-3.FC3.1
postgresql-7.4.7-3.FC3.1
postgre
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
Are you using the latest selinux_policy_targeted package? I mean, is your
system up2date?
Regards,
On Wed, 9 Mar 2005, Ulrich Wisser wrote:
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from fedora
savely? OR is there any wa
Hi,
it seems selinix doesn't like postgres. Can I uninstall selinux from
fedora savely? OR is there any way to make them both work together?
Here is my error message:
Mar 9 14:20:33 localhost kernel: audit(1110374433.961:0): avc: denied
{ read } for pid=9251 exe=/usr/bin/postgres name=PG_VER
32 matches
Mail list logo
