Hello Team,
We are getting below error while migrating pg_dump from Postgresql 9.6 to
Postgresql 11.2 via pg_restore in docker environment.
90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from T
On 4/21/19 9:35 AM, Daulat Ram wrote:
Hello Team,
We are getting below error while migrating pg_dump from Postgresql 9.6
to Postgresql 11.2 via pg_restore in docker environment.
90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19"
pg_restore: [archiver (db)] Error while PROCESSING TOC
Adrian Klaver writes:
> On 4/21/19 9:35 AM, Daulat Ram wrote:
>> pg_restore: [archiver (db)] could not execute query: ERROR: schema
>> "public" already exists
>> Command was: CREATE SCHEMA public;
> Expected as the public schema is there by default. It is an
> informational error, you can ignor
I'm so close but I can't quite figure out how to match view columns to
their source columns in a query. Looks like I might need yet another
table to join that makes that match, but I'm not having any success
finding such a bridge. Matching views to their source tables works well
enough. What
On 4/21/19 1:46 PM, Adrian Klaver wrote:
On 4/21/19 9:35 AM, Daulat Ram wrote:
Hello Team,
We are getting below error while migrating pg_dump from Postgresql 9.6 to
Postgresql 11.2 via pg_restore in docker environment.
90d4c9f363c8:~$ pg_restore -d kbcn "/var/lib/kbcn_backup19"
pg_restore:
On 4/21/19 1:42 PM, Ron wrote:
On 4/21/19 1:46 PM, Adrian Klaver wrote:
On 4/21/19 9:35 AM, Daulat Ram wrote:
Hello Team,
We are getting below error while migrating pg_dump from Postgresql
9.6 to Postgresql 11.2 via pg_restore in docker environment.
90d4c9f363c8:~$ pg_restore -d kbcn "/var/
On 4/21/19 3:58 PM, Adrian Klaver wrote:
On 4/21/19 1:42 PM, Ron wrote:
On 4/21/19 1:46 PM, Adrian Klaver wrote:
On 4/21/19 9:35 AM, Daulat Ram wrote:
Hello Team,
We are getting below error while migrating pg_dump from Postgresql 9.6
to Postgresql 11.2 via pg_restore in docker environment.
Hi,
I don't know if it is possible ...
the only way I found seems to use pg_depend and pg_rewrite
as described here
https://pgdba.org/post/2018/04/dependency_ladder/
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
On 4/21/19 2:20 PM, Ron wrote:
I see this sort of thing in monitoring systems e.g. environmental
controls all the time. Things get flagged because they wander over set
points intermittently. It is technically an error but unless they stay
over the line it is just another data point.
Errors n
Susan Hurst wrote:
> I'm so close but I can't quite figure out how to match view columns to
> their source columns in a query.
There is no simple way to find which view column matches which column
in the original table. Don't forget that the column could be defined
as an expression that involves
Hello All,
CentOS Linux release 7.5.1804 (Core)
Postgres 10.7.
When "create extension "uuid-ossp"", I got :
2019-04-22 02:41:53.323 UTC [10305] XX000ERROR: XX000: cache lookup
failed for function 1
2019-04-22 02:41:53.323 UTC [10305] XX000LOCATION:
fmgr_info_cxt_security, fmgr.c:184
2019-04-2
11 matches
Mail list logo
