Hi,
Recently two of our database servers crashed and won't start. The errors
in postgres logs are:
Server 1:
2017-07-16 11:36:12 UTC PANIC: could not access status of transaction
392483501
2017-07-16 11:36:12 UTC DETAIL: Could not read from file
"pg_multixact/members/14077" at offset 90112
J Ottery wrote:
Using XP Pro and Postgres 8.3
I made a backup of the "Data" directory of the Postgres Installation
to another place on the hard disk.
Now the customer has uninstalled postgres then reinstalled a new one.
Of course the original tables are all gone.
Is there a method of retrieving t
On Jul 14, 12:57 pm, J Ottery <[EMAIL PROTECTED]> wrote:
> Using XP Pro and Postgres 8.3
> I made a backup of the "Data" directory of the Postgres Installation
> to another place on the hard disk.
> Now the customer has uninstalled postgres then reinstalled a new one.
> Of course the original table
Using XP Pro and Postgres 8.3
I made a backup of the "Data" directory of the Postgres Installation
to another place on the hard disk.
Now the customer has uninstalled postgres then reinstalled a new one.
Of course the original tables are all gone.
Is there a method of retrieving the original tables
veejar wrote:
Unfortunately I don't have any other information: dumps, other folders
from pgsql root directory.
What tools?
Start here:
http://sources.redhat.com/rhdb/
And you'll want to read and understand the Internals/Physical Storage
chapters of the manuals.
From past experience recov
veejar wrote:
Hello!
I had problems with my HDD and i have lost many files. From my pgsql
database files I have only "base"-folder. In this folder one is
important database:
base/45325101
How to correct this one database?
You can't. You need all the files in data/ - recover the whole cluste
Hello!
I had problems with my HDD and i have lost many files. From my pgsql
database files I have only "base"-folder. In this folder one is
important database:
base/45325101
I reinstall my postgresql-server.
I have created new database with same name and have copied all files
from my old folder
In article <[EMAIL PROTECTED]>,
RPK <[EMAIL PROTECTED]> wrote:
% I tried to modify the parameters of the .CONF file when the pgsql-8.1
% service was running. The next time I started, it displayed error: "The
% service did not listen to local host". (something like this).
%
% So I copied the old D
I tried to modify the parameters of the .CONF file when the pgsql-8.1service was running. The next time I started, it displayed error: "The
service did not listen to local host". (something like this).If you were to do a"su - postgres -c "pg_ctl -D start" what error information does it show?
Stev
>Was the old postgres stopped when you created the copy?
>Was the new postgres stopped when you put the copy in?
>Did you restore correct permissions when you put the copy in?
>Is the new install the same version of postgres as the old one?
>What are the error messages?
I t
# [EMAIL PROTECTED] / 2006-08-07 22:17:26 -0700:
>
> I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
> I do not have any DUMP or other backups. I want to use this folder instead
> of the newly created DATA folder after new installtion.
>
> I tried replacing the new f
I have a DATA folder of my previous PostgreSQL 8.1 (Windows XP) installation.
I do not have any DUMP or other backups. I want to use this folder instead
of the newly created DATA folder after new installtion.
I tried replacing the new folder with the old folder, but it did not work.
pgAdmin also
On Wed, 2005-10-19 at 15:55 +0200, [EMAIL PROTECTED] wrote:
> Hi Sven
>
> Thanks for the help. This looks like the kind of info I needed.
> One question:
> You suggest that I use : pkg_add -r postgresql80-server. If this requires
> postgresql80-client, will it automatically download it and install
Hi Sven
Thanks for the help. This looks like the kind of info I needed.
One question:
You suggest that I use : pkg_add -r postgresql80-server. If this requires
postgresql80-client, will it automatically download it and install? The
docs I have read suggest this, but maybe you can confirm?
Thanks
Hi Sven
Thanks for the info. This is a great help.
One question:
> On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
>> Hi
>>
>> I am very new to FreeBSD (Windows Background), but am busy trying to
>> implement a PostgreSQL database that I have running in the Windows
>> environemtn on F
On Wed, 2005-10-19 at 08:23 +0200, [EMAIL PROTECTED] wrote:
> Hi
>
> I am very new to FreeBSD (Windows Background), but am busy trying to
> implement a PostgreSQL database that I have running in the Windows
> environemtn on FreeBSD. Naturally, most of my problems so far have been
> geeting to grip
On 19.10.2005 08:23, [EMAIL PROTECTED] wrote:
I excluded
/cube and /mysql from the MakeFile (cube seemed to be failing and why
would I want mysql stuff on PostgreSQL?). I then did a gmake install. All
contribs seemed to install fine. I reran the restore on a clean DB and
most of the errors went a
Hi
I am very new to FreeBSD (Windows Background), but am busy trying to
implement a PostgreSQL database that I have running in the Windows
environemtn on FreeBSD. Naturally, most of my problems so far have been
geeting to grips with FreeBSD.
Anyway, I am having a problem at the moment. Having bei
On Mon, Dec 22, 2003 at 08:14:51PM -0300, Lucas Lain wrote:
> > If it's a plain text dump, make a copy of the backup file. Edit the
> > copy and delete everything that doesn't relate to the database to be
> > restored.
>
> it's quite large to do this ...
Maybe you could try getting the line num
>
> If it's a plain text dump, make a copy of the backup file. Edit the
> copy and delete everything that doesn't relate to the database to be
> restored.
it's quite large to do this ...
> If you dumped in tar or special format, I believe you can use
> pg_restore -d dbname
> but I haven't don
On Mon, 2003-12-22 at 14:51, Lucas Lain wrote:
> Hi everybody ... i need to restore only one database from a pg_dumpall backup
> file... how can i do it?
If it's a plain text dump, make a copy of the backup file. Edit the
copy and delete everything that doesn't relate to the database to be
resto
"Gordan Bobic" <[EMAIL PROTECTED]> writes:
> Can somebody please explain to me why is it that 20 Gb of disk space
> is required to restore 5 GB of data?
You may wish to apply the patch at
http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html
> What is going on? I have had this
22 matches
Mail list logo
