Re: A very puzzling backup/restore problem

2019-10-24 Thread Tom Lane
Adrian Klaver writes: > On 10/24/19 2:58 PM, stan wrote: >> So, it appears that this means that the function cannot be found, even if it >> is in the new >> (default) schema. > The original error was not about finding the function it was about not > finding the table in the function: > psql:ta

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
On 10/24/19 2:58 PM, stan wrote: On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote: On 10/24/19 7:32 AM, stan wrote: On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: On 10/24/19 3:52 AM, stan wrote: I have a very confusing isse. I am trying to backup and restre a

Re: A very puzzling backup/restore problem

2019-10-24 Thread stan
On Thu, Oct 24, 2019 at 07:40:29AM -0700, Adrian Klaver wrote: > On 10/24/19 7:32 AM, stan wrote: > > On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: > > > On 10/24/19 3:52 AM, stan wrote: > > > > > > > > > > > > I have a very confusing isse. I am trying to backup and restre a si

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
On 10/24/19 7:32 AM, stan wrote: On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: On 10/24/19 3:52 AM, stan wrote: I have a very confusing isse. I am trying to backup and restre a signle table . first I dump the table. Actually you are just dumping the table data. More below

Re: A very puzzling backup/restore problem

2019-10-24 Thread stan
On Thu, Oct 24, 2019 at 07:04:11AM -0700, Adrian Klaver wrote: > On 10/24/19 3:52 AM, stan wrote: > > > > > > I have a very confusing isse. I am trying to backup and restre a signle > > table . > > > > first I dump the table. > > Actually you are just dumping the table data. > > More below. >

Re: A very puzzling backup/restore problem

2019-10-24 Thread Adrian Klaver
On 10/24/19 3:52 AM, stan wrote: I have a very confusing isse. I am trying to backup and restre a signle table . first I dump the table. Actually you are just dumping the table data. More below. Script started on 2019-10-24 06:29:12-0400 ]0;stan@smokey: ~stan@smokey:~$ pg_dump -a --tab

Re: A very puzzling backup/restore problem

2019-10-24 Thread stan
On Thu, Oct 24, 2019 at 07:57:14AM -0500, Ron wrote: > Why did you do "\i task_instance.dump" instead of "pg_restore"? Ah, that may be the root of my problem. I had in the back of my mind that the result of a pg_dump was a free standing SQL script, but that my be exactly what is going on. I will

A very puzzling backup/restore problem

2019-10-24 Thread stan
I have a very confusing isse. I am trying to backup and restre a signle table . first I dump the table. Script started on 2019-10-24 06:29:12-0400 ]0;stan@smokey: ~stan@smokey:~$ pg_dump -a --table task_instance > task_instance.dump Then I connect to the db, and verify that things are as