If I ask this question without mention the PG version I upgrade from and
to, and don't mention the operating system, and don't mention replication,
would the standard answer be:
Use pg_upgrade!
I have looked through
https://www.postgresql.org/docs/9.6/static/pgupgrade.html
but it seems more comp
2017-07-05 15:41 GMT+02:00 Adrian Klaver :
>
> [scheme[<+>dsn]]://[[username[:[password]]@][host][:port][/[
> dbname][/[[table[/[column[,column...]*]]]|sql]]]
> ^
>
> The thing is that in a quick search on this I did not find a reference
> implementation of
2017-07-05 16:29 GMT+02:00 Thomas Kellerer :
> Hans Schou schrieb am 05.07.2017 um 14:27:
> > The dburl (or dburi) has become common to use by many systems
> > connecting to a database. The feature is that one can pass all
> > parameters in a string, which has similar p
2017-07-05 15:15 GMT+02:00 Albe Laurenz :
>
> Unless I misunderstand, this has been in PostgreSQL since 9.2:
>
Sorry! I did not read the *new* manual.
(OK, 9.2 is not that new)
It is even mentioned in the man page.
Then I have a new proposal. Write a note about in
psql --help
./hans
Hi
The dburl (or dburi) has become common to use by many systems connecting to
a database. The feature is that one can pass all parameters in a string,
which has similar pattern as http-URI do.
Especially when using psql in a script, having the credentials in one
string is convenient.
The syntax
Hi
We have a system with several users. Sometimes one of the users make a
mistake with his data and want to restore, like he want to do an undo. Only
one user should be restored, not all users.
I work as sysadm so I can not change the system, but has to solve the task
at this level.
My approach
Hi
I have a little trouble with the chr() function.
I have a string like this:
"Copyright+%C2%A9+1856+Na%C3%AFve+retros%C2%AE"
which should be converted to binary string like:
"Copyright © 1856 Naïve retros®"
Is there an easy way to do this conversion?
I have tried to do it with a function, bu
