On Sat, Oct 26, 2019 at 11:02:26AM -0700, Adrian Klaver wrote:
> Not sure how that can be answered without knowing what ComputeComputer is
> doing?
Yes, there is nothing of this kind in the PostgreSQL code. So you may
want to check your own extension code if a module is involved here, or
perhaps
On Sat, 26 Oct 2019, Adrian Klaver wrote:
Just me, but to keep this from being a 'famous last words' moment I would
backup up the new(11.5) instance before proceeding.
Adrian,
Okay. That makes good sense. Will do a pg_dumpall on the 11.5 cluster.
When I'm actively working on a database I do
On 10/26/19 1:39 PM, Rich Shepard wrote:
On Sat, 26 Oct 2019, Adrian Klaver wrote:
Then the question is, do you really want to overwrite the new database?
Adrian,
I want to overwrite the old databases with the new .sql file. I _think_
there's only one database that's changed, but overwriting
Or if you know any link to a website where to find an example of this, I
will thank you very much, please.
Best regards,
Yessica Brinkmann
El vie., 25 oct. 2019 a las 22:06, Yessica Brinkmann (<
yessica.brinkm...@gmail.com>) escribió:
> Good evening, sorry for the delay in answering. I have a par
On Sat, 26 Oct 2019, Adrian Klaver wrote:
Then the question is, do you really want to overwrite the new database?
Adrian,
I want to overwrite the old databases with the new .sql file. I _think_
there's only one database that's changed, but overwriting all won't hurt.
Regards,
Rich
On 10/26/19 10:39 AM, Rich Shepard wrote:
On Sat, 26 Oct 2019, Adrian Klaver wrote:
That depends on how you ran pg_dumpall. For instance did you use -c?:
Adrian,
Yes. Always.
Then the question is, do you really want to overwrite the new database?
https://www.postgresql.org/docs/11/sql-
On 10/25/19 5:19 PM, ZhenHua Cai wrote:
Hi All
I encountered one problem. It repeats again and again. Please help.
"ComputeComputer" is one stored procedure. The version of PostgreSQL I
am using is 12.
2019-10-26 07:36:58.880 HKT [5376] CONTEXT: SQL function
"ComputeComputer" statement 1
Hi All
I encountered one problem. It repeats again and again. Please help.
"ComputeComputer" is one stored procedure. The version of PostgreSQL I am
using is 12.
2019-10-26 07:36:58.880 HKT [5376] CONTEXT: SQL function "ComputeComputer"
statement 1
2019-10-26 07:36:58.880 HKT [5376] STATEMENT:
On Sat, 26 Oct 2019, Adrian Klaver wrote:
That depends on how you ran pg_dumpall. For instance did you use -c?:
Adrian,
Yes. Always.
https://www.postgresql.org/docs/11/sql-alterdatabase.html
ALTER DATABASE name RENAME TO new_name
Ah, I should have looked. I apologize.
Rich
On 10/26/19 8:38 AM, Rich Shepard wrote:
Before my old server died I ran pg_dumpall on the database there and copied
that to my new server. The old database was postgresql-10 and the new
one is
postgresql-11.5.
Am I correct that I can run 'pgsql -f .sql' and overwrite the
existing databases wi
Before my old server died I ran pg_dumpall on the database there and copied
that to my new server. The old database was postgresql-10 and the new one is
postgresql-11.5.
Am I correct that I can run 'pgsql -f .sql' and overwrite the
existing databases with the newer data?
Checking the database na
11 matches
Mail list logo
