23 Bře
2021
23 Bře
'21
22:40
Hi Paulos,
if you are doing restore of database, you should probably do this into
empty database or if you have "create database" as part of dump, you
can remove database at the destination system completely.
Regards,
Jaromir
On Tue, 2021-03-23 at 10:28 +0200, Dr Paulos Nyirenda wrote:
On 19 Mar 2021 at 14:06, Jaromir Talir wrote:
Hi Paulos,
I'm not sure if I got it right. There are two scenarios:
1/ You do DUMP + RESTORE and information in restored tables is
different than in original table.
This would be weird. I can only imagine that DUMP failed or was
incomplete but otherwise there should be no issue
This is the issue. When we do a DUMP and RESTORE, the mail_template
on the system on
which we do a restore remains the same, it is not updated from the
restore in the DUMP.
As such we have to manually edit it again to get it updated.
2/ You do DUMP + modification + RESTORE and
modification is not in
restored tables.
We do not do a modification after doing the DUMP.
This is also correct since modifications are not
included in DUMP.
I
suggest to make backup via DUMP after modification of those tables.
After a bit of reading and when I get the time, I am now going to try
to do a data only dump of
the mail_template table with the data that we want and then see if I
canm restore that data
only after the restore using the aproach suggested in the attached
advice, would that work ?
Regards,
Paulos
=============================
Dr Paulos B Nyirenda
NIC.MW & .mw ccTLD
http://www.nic.mw
SDNP: http://www.sdnp.org.mw
Tel: +265-(0)-882 089 166
Cell: +265-(0)-888-824787
WhatsApp: +265-(0)-887386433
Regards,
Jaromir
On Thu, 2021-03-18 at 15:39 +0200, Dr Paulos Nyirenda wrote:
The following section of this message contains a file attachment
prepared for transmission using the Internet MIME message format.
If you are using Pegasus Mail, or any other MIME-compliant system,
you should be able to save it or view it from within your mailer.
If you cannot, please ask your system administrator for assistance.
---- File information -----------
File: postgreSQL-backup and restore-table-data-
makandracards.pdf
Date: 18 Mar 2021, 16:58
Size: 285252 bytes.
Type: Unknown
Good afternoon,
I am having trouble maintaing my English version of mail_template
table in the FRED database backup and restore, can you help ?
I often need to backup the FRED registry system database and I am
using
#pg_dump -U fred fred > fred-backup-file.sql
To restore that database I use
#sudo -u postgres psql
#DROP DATABASE fred;
#CREATE DATABASE fred;
#\q
#psql -U fred -d fred -f fred-backup-file.sql
However, I find in almost all cases that I lose any updates that
I
made on mail_template table when I restore this way on the new
restoration.
Is there a way that I can keep the most resent mail_template
updates
between backup and restore?
I have tried to save the mail_template using a dump like
#pg_dump -U fred fred -t mail_template > fred-mail_template-
bkp.sql
but I am unable to restore this because I get the error that
there
are too many dependencies on mail_template when I try to drop the
table and then use pg_restore -t.
So, what is the best way of moving with my desired mail_template
in
FRED?
Can I do this even between different schemas of backup and
restore ?
Regards,
Paulos
=============================
Dr Paulos B Nyirenda
NIC.MW & .mw ccTLD
http://www.nic.mw
SDNP: http://www.sdnp.org.mw
Tel: +265-(0)-882 089 166
Cell: +265-(0)-888-824787
WhatsApp: +265-(0)-887386433