Sample for building forms based on a Postgres DB

This forum is meant for examples of X# code.

User avatar
lumberjack
Posts: 726
Joined: Fri Sep 25, 2015 3:11 pm
Location: South Africa

Sample for building forms based on a Postgres DB

Post by lumberjack »

Hello Rainer,
RGreim4XS wrote:Hi,
I have now a working environment with a Postgres Server running on a IMac .
But what is the best way to do it with XIDE/ VS ?
Do I need extra paid libs / runtimes ?
I remember from my past, everytime I say enterprise or server I have to spent extra money.
This is one of the reasons why.I’m still using DBFs .
Thx for pointing me to PostgressSQL in my last post ( database question)
Sorry for late reply, but was without internet for 2 months.

As Wolfgang and others, I am also a fan of PG. I am also doing Data-driven and have a couple of articles in the Download section which might help you.

Feel free to contact me if you need any help, specially with dynamic PG stuff.

Kind regards
______________________
Johan Nel
Boshof, South Africa
RGreim4XS
Posts: 41
Joined: Sat Feb 08, 2020 7:47 am

Sample for building forms based on a Postgres DB

Post by RGreim4XS »

Hi, thx for the great support.
Rainer
Juraj
Posts: 161
Joined: Mon Jan 09, 2017 7:00 am

Sample for building forms based on a Postgres DB

Post by Juraj »

Hi Johan,
how to transfer a postgres database from client computer to another computer without a network?

Juraj
User avatar
lumberjack
Posts: 726
Joined: Fri Sep 25, 2015 3:11 pm
Location: South Africa

Sample for building forms based on a Postgres DB

Post by lumberjack »

Juraj,
Juraj wrote:Hi Johan,
how to transfer a postgres database from client computer to another computer without a network?
Juraj
The "official" way is to use pg_backup and pg_restore.
You can also backup/restore from pgAdmin.

If the computers have the exact same setup and version, I have also simply copied the PostgreSQL data folder with subfolders onto the other computer. Just make sure you stop the PG services before you do it.

HTH
______________________
Johan Nel
Boshof, South Africa
User avatar
wriedmann
Posts: 3753
Joined: Mon Nov 02, 2015 5:07 pm
Location: Italy

Sample for building forms based on a Postgres DB

Post by wriedmann »

Hi Juraj,
I'm using this script to save to a .gz file (Linux):

Code: Select all

su - postgres -c "pg_dump -c db90273">/root/db90273.sql
gzip /root/db90273.sql
mv /root/db90273.sql.gz /home/Daten/temp/
and this one to restore:

Code: Select all

mv /home/Daten/Temp/db90273.sql.gz .
gunzip db90273.sql.gz
su - postgres -c 'psql db90273'<db90273.sql
rm db90273.sql
Wolfgang
Wolfgang Riedmann
Meran, South Tyrol, Italy
wolfgang@riedmann.it
https://www.riedmann.it - https://docs.xsharp.it
Post Reply