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:
> >
> > 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
> >
> >
>
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