On 07.07.21 08:53, Luca Ferrari wrote:
Hi all,
someone pointed me out that pg_upgrade can be used to do a clone of
the database, specifying the same binaries such as
pg_upgrade -B /usr/pgsql-13/bin -b /usr/pgsql-13/bin -D /data/clone -d /data/src
I tested it and it seems to work, even if I don'
On Wed, Jul 7, 2021 at 10:22 AM Peter Eisentraut
wrote:
> Yeah, seems pretty pointless. You can just copy the data directory
> directly and get the same effect. pg_upgrade basically does a data
> directory copy plus some extra stuff to convert the system catalogs
> between versions, and if you d
On Wed, Jul 7, 2021 at 3:22 AM Lucas wrote:
>
> Hello all,
>
> I'm currently working on a migration from PG 9.2 to PG 13 (RDS) and would
> like some suggestions, please.
>
> Our current database stack is:
>
> master (pg 9.2) --> slave (pg 9.2) --> slave (pg 9.2 - cascading replication)
>
At Mon, 5 Jul 2021 16:45:09 +0530, Atul Kumar wrote in
> hi,
>
> (on postgres 9.6) I was just practicing to make my no. of wal files in
> pg_xlog directory to be the same/equal as I pass on wal_keep_segments
> paramater.
>
> say for example
> show wal_keep_segments;
> wal_keep_segments
> -
Created by: gzhcoder
Email address: gzhco...@126.com
PostgreSQL version: 12.6
Operating system: windows 10
Description:
I have a classic ASP Website on IIS. I change the “ Enable 32-bit
Applications ” to True (Set the IIS application pool to spawn in a 32-bit
mode).
hi,
Try with a newer version of odbc driver, something like psqlodbc_12_02_
On 07/07/2021 07:38, 管竚 wrote:
Created by: gzhcoder
Email address: gzhco...@126.com
PostgreSQL version: 12.6
Operating system: windows 10
Description:
I have a classic ASP Website on IIS. I chang
On Sat, Jul 3, 2021 at 10:36 AM Rama Krishnan wrote:
>
>
> Hi Team,
>
> How can I split read and write queries using pgbouncer
Check out pgbouncer-rr. I haven't used it, but it may do what you need.
merlin
On Wed, Jul 7, 2021 at 10:30:15AM +0200, Luca Ferrari wrote:
> On Wed, Jul 7, 2021 at 10:22 AM Peter Eisentraut
> wrote:
> > Yeah, seems pretty pointless. You can just copy the data directory
> > directly and get the same effect. pg_upgrade basically does a data
> > directory copy plus some ext
>hi,
>Try with a newer version of odbc driver, something like psqlodbc_12_02_
Dear Diego,
What a helpful reply. Thank you for the time you put into getting back to me.
I really want you to know how much I appreciate that.
The ASP WebSite now works perfectly with no issues connecting to the
