xsharp.eu

Posted: **Mon Jun 21, 2021 10:17 am**

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

Posted: **Mon Jun 21, 2021 8:17 pm**

Hi, thx for the great support.
Rainer

Posted: **Tue Jun 22, 2021 10:37 am**

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

Juraj

Posted: **Tue Jun 22, 2021 10:52 am**

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

Posted: **Tue Jun 22, 2021 11:06 am**

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

xsharp.eu

Sample for building forms based on a Postgres DB

Sample for building forms based on a Postgres DB

Sample for building forms based on a Postgres DB

Sample for building forms based on a Postgres DB

Sample for building forms based on a Postgres DB

Sample for building forms based on a Postgres DB