Hi!
Would it not be easier to just set up another Debian server, run binary
replication
Breaks occurs rarely, 0-2 times per year.
I want try it first.
and put them behind something like pgpool?
Backup server will use single core and minimal RAM. It may be needed 0-2
times per year.
pgpo
Hi,
On 2020-03-30 00:49:13 +0200, Peter J. Holzer wrote:
> I noticed this with PostgreSQL 11.7 on Linux:
>
> I did a «vacuum full» on a table which had become quite bloated (size
> before the vacuum: 392 GB, after: 291 GB). I expected the disk usage to
> increase as the new table was written and
On 2020-03-26 21:33:51 +0100, Christoph Moench-Tegeder wrote:
> ## Ted To (t...@theo.to):
> > Thank you -- I added two lines to the hba file to allow for ident
> > authentication, restarted postgres and still the same errors.
>
> You probably don't want "ident" authentication - that's the thing
>
I noticed this with PostgreSQL 11.7 on Linux:
I did a «vacuum full» on a table which had become quite bloated (size
before the vacuum: 392 GB, after: 291 GB). I expected the disk usage to
increase as the new table was written and then drop sharply after the
vacuum was finished.
However, that didn
Hi!
Same warning appears two times. This command execute by pg_restore
probably causes this (harmless?) warning:
What warning?
pg_restore: WARNING: could not determine encoding for locale "et_EE.UTF-8":
codeset is "CPUTF-8"
I cranked up a Windows 7 instance and tried to migrate a Postgres
On 3/29/20 11:12 AM, Andrus wrote:
Hi!
There seems to a difference of opinion of what Baltic Code Page to use:
https://en.wikipedia.org/wiki/Code_page_775
https://en.wikipedia.org/wiki/Windows-1257
The post below shows a users method of dealing with this for another CP:
https://www.postgresql.o
On 3/29/20 12:52 PM, Andrus wrote:
Hi!
Since you are moving between different OSes you will need to use some
form of logical replication as binary replication will not work.
I can use Hyper-V or something other to run Debian with Windows.
This hopefully will also allow to bypass Windows 20 c
Hi!
Since you are moving between different OSes you will need to use some form
of logical replication as binary replication will not work.
I can use Hyper-V or something other to run Debian with Windows.
This hopefully will also allow to bypass Windows 20 connection limit so that
more than 2
Hi!
Per my previous post, you might try adding something like:
cmd.exe /c chcp 1257
to the top of the batch file. This idea came from here:
https://stackoverflow.com/questions/20794035/postgresql-warning-console-code-page-437-differs-from-windows-code-page-125
If I am following the error correct
Hi!
There seems to a difference of opinion of what Baltic Code Page to use:
https://en.wikipedia.org/wiki/Code_page_775
https://en.wikipedia.org/wiki/Windows-1257
The post below shows a users method of dealing with this for another CP:
https://www.postgresql.org/message-id/549275CC.4010607%40gma
On 3/29/20 5:35 AM, Andrus wrote:
Hi!
Postgres 12 server is running on Debian 10 and has number of databases.
How to mirror changes of those databases to Windows 10 workstation which
runs also Postgres 12.
Changes in server databases in Debian should sent to Postgres 12
database in Windows
On 3/29/20 1:02 AM, Andrus wrote:
Hi!
Generally speaking, locale names from Unix systems won't work at all on
Windows. You need to create the database manually with whatever seems
to be the closest Windows locale match, and then restore its contents
without using --create.
This is unattended
On 3/29/20 12:56 AM, Andrus wrote:
Hi!
System Locale: et;Eesti
Input Locale: et;Eesti
Hmm, I was expecting to see et_EE though I will admit to not truly
understanding how Windows does locales.
I should have asked earlier, in the Postgres instance on Windows what
does
Hi all,
is there any possibility to get char "coordinates", not only token
"coordinates" from tsvector or, basically, text parser? Like in
Elasticsearch
GET _analyze?text=This fox is brown&analyzer=english
{
"tokens": [
{
"token": "fox",
"start_offset": 5,
"end_offset": 8,
"type": "",
Hi!
Postgres 12 server is running on Debian 10 and has number of databases.
How to mirror changes of those databases to Windows 10 workstation which
runs also Postgres 12.
Changes in server databases in Debian should sent to Postgres 12 database in
Windows over internet.
If Debian server g
Hi!
System Locale: et;Eesti
Input Locale: et;Eesti
Hmm, I was expecting to see et_EE though I will admit to not truly
understanding how Windows does locales.
I should have asked earlier, in the Postgres instance on Windows what does
\l show for template0?
"D:\Program
Hi!
Generally speaking, locale names from Unix systems won't work at all on
Windows. You need to create the database manually with whatever seems
to be the closest Windows locale match, and then restore its contents
without using --create.
This is unattended script running in every night from
On Sat, Mar 28, 2020 at 11:29:41AM -0700, Andres Freund wrote:
> I assume you're still trying to track the actual cause of the problem
> further?
That's the plan, and I'll try to spend some time on it next week. Any
new information I have will be added to the thread you have begun on
-hackers a c
18 matches
Mail list logo
