Re: db restore from sql file

2021-02-22 Thread Dave Page
On Mon, Feb 22, 2021 at 3:22 PM James B. Byrne wrote: > > > On Mon, February 22, 2021 04:14, Dave Page wrote: > > On Fri, Feb 19, 2021 at 8:00 PM James B. Byrne > > wrote: > > > >> > >> Is there no way to restore from an sql file from within pgadmin4? > >> > > > > Not at present, because pg_rest

Re: db restore from sql file

2021-02-22 Thread James B. Byrne
On Mon, February 22, 2021 04:14, Dave Page wrote: > On Fri, Feb 19, 2021 at 8:00 PM James B. Byrne > wrote: > >> >> Is there no way to restore from an sql file from within pgadmin4? >> > > Not at present, because pg_restore can't do it. You'd need to feed the file > into the psql command line u

Re: db restore from sql file

2021-02-22 Thread Dave Page
On Fri, Feb 19, 2021 at 8:00 PM 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

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