On 23 Mar 2021 at 22:40, Jaromir Talir wrote:
> 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.
Ahhh ... but I do, I think, as follows:
########### stop fred servers first
#sudo -u postgres psql
#DROP DATABASE fred;
#CREATE DATABASE fred;
#\q
# psql -U fred -d fred -f fred-backup-file.
Does this not satisfy this ?
After this I do a db upgrade:
# su - postgres -c "/usr/sbin/fred-dbmanager upgrade"
which runs ok, however, the resulting mail_template table is different from the one in the
dump, all the cz entries show up again and the English editing is gone.
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 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
>
