Re: db restore from sql file

2021-02-19 Thread Endre Pekarik
I like “ but be prepared for a very very very long restore time... very very very long as in you don't want this”  Sent from Yahoo Mail for iPhone On Friday, February 19, 2021, 3:58 PM, Guillaume Lelarge wrote: Hi, Le ven. 19 févr. 2021 à 21:08, James B. Byrne a écrit : On Fri, February

Re: db restore from sql file

2021-02-19 Thread Guillaume Lelarge
Hi, Le ven. 19 févr. 2021 à 21:08, James B. Byrne a écrit : > > > On Fri, February 19, 2021 15:04, James B. Byrne wrote: > > > > > > On Fri, February 19, 2021 15:00, James B. Byrne wrote: > >> > >> > >> Is there no way to restore from an sql file from within pgadmin4? > >> > As far as I can tel

Re: db restore from sql file

2021-02-19 Thread James B. Byrne
On Fri, February 19, 2021 15:04, James B. Byrne wrote: > > > On Fri, February 19, 2021 15:00, James B. Byrne wrote: >> >> >> Is there no way to restore from an sql file from within pgadmin4? >> >> > > I can load it as an SQL query of course. And I tried that. But the dump file > contains this

Re: db restore from sql file

2021-02-19 Thread James B. Byrne
On Fri, February 19, 2021 15:00, James B. Byrne wrote: > I used pgadmin4 to create a dump file in plain sql. > > I am trying to use this file to populate a test database on another postgresql > host. I can find the file previously created. It appears correct: > > [root@vhost01 ~ (master)]# fil

db restore from sql file

2021-02-19 Thread James B. Byrne
I used pgadmin4 to create a dump file in plain sql. I am trying to use this file to populate a test database on another postgresql host. I can find the file previously created. It appears correct: [root@vhost01 ~ (master)]# file /var/db/pgadmin4/storage/admin_harte-lyne.ca/redmine_backup_locate

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread James B. Byrne
On Fri, February 19, 2021 09:10, Dave Page wrote: > Hi > > > A couple of possibilities spring to mind: > > 1) Python hasn't noticed the update, and is using the older bytecode. Try > searching for and removing any __pycache__ directories under > /opt/python_venv/3.7/pgadmin4/lib/python3.7/site-

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread Dave Page
Hi On Fri, Feb 19, 2021 at 2:05 PM James B. Byrne wrote: > > > On Fri, February 19, 2021 04:33, Dave Page wrote: > > Hi > > > > On Thu, Feb 18, 2021 at 7:34 PM James B. Byrne > > wrote: > > > >> When starting pgadmin4 in a python venv I get a warning that I am > starting > >> version 4.27 and t

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread James B. Byrne
On Fri, February 19, 2021 04:33, Dave Page wrote: > Hi > > On Thu, Feb 18, 2021 at 7:34 PM James B. Byrne > wrote: > >> When starting pgadmin4 in a python venv I get a warning that I am starting >> version 4.27 and that 4.30 is available. >> >> However, I have updated that venv to 4.30: >> . .

Re: pgadmin-4.30 upgrade from 4.27

2021-02-19 Thread Dave Page
Hi On Thu, Feb 18, 2021 at 7:34 PM James B. Byrne wrote: > When starting pgadmin4 in a python venv I get a warning that I am starting > version 4.27 and that 4.30 is available. > > However, I have updated that venv to 4.30: > > [root@vhost01 ~ (master)]# source > /opt/python_venv/3.7/pgadmin4/bi