Pg_dump or do a wal archive.
Thanks,
Ben
On Fri, Feb 4, 2022, 10:49 PM Ron wrote:
> On 2/4/22 9:14 PM, sivapostg...@yahoo.com wrote:
>
> Hello,
> Got few (currently 3 will increase as days go) database in A2 hosting
> unmanaged vps server, running Ubuntu server 18 lts
>
> Planning to have an ad
On 2/4/22 9:14 PM, sivapostg...@yahoo.com wrote:
Hello,
Got few (currently 3 will increase as days go) database in A2 hosting
unmanaged vps server, running Ubuntu server 18 lts
Planning to have an additional backup of all files, including pg database,
to another cloud provider like Amazon S3
Hello,Got few (currently 3 will increase as days go) database in A2 hosting
unmanaged vps server, running Ubuntu server 18 lts
Planning to have an additional backup of all files, including pg database, to
another cloud provider like Amazon S3 (any other suggestions?)
Size won't be crossing 5GB pe
On 2/4/22 12:17, rob stan wrote:
Thanks Pavel. Do you know pgq is compatible with
postgresql-server-dev-14 packages? I couldn't see any requirements or
something documented for pgq and postgres 14.
From here:
https://github.com/pgq/pgq/releases
it looks like it only officially goes to versio
Thanks Pavel. Do you know pgq is compatible with postgresql-server-dev-14
packages? I couldn't see any requirements or something documented for pgq
and postgres 14.
Pavel Stehule , 4 Şub 2022 Cum, 01:17 tarihinde
şunu yazdı:
> Hi
>
> pá 4. 2. 2022 v 7:02 odesílatel rob stan napsal:
>
>> Hello,
>
On 2/4/22 05:21, A Shaposhnikov wrote:
Tomas,
thank you! The query:
select 1 from data as d, data_class as dc
where dc.data_id = d.id and d.id > 205284974
and dc.data_id > 205284974 -- new condition
order by d.id
limit 1000;
totally solved it - it is now fast under all
Matthias Apitz writes:
> Said that, does the SORT done by the server depends on the environment
> (LANG, LC_*) in which the PostgreSQL server is started or only of the
> sp_catalog information of the database in question?
We set LC_COLLATE and LC_CTYPE from the database's relevant
pg_database fie
El día Donnerstag, Februar 03, 2022 a las 10:00:37 -0500, Tom Lane escribió:
> Matthias Apitz writes:
> > El día jueves, febrero 03, 2022 a las 11:14:55 +0100, Matthias Apitz
> > escribió:
> >> With ESQL/C on a PostgreSQL 13.1 server I see the result of this query:
> >> select katkey,normform fr