Adrian Klaver wrote:
> On 7/13/19 4:30 AM, Laurenz Albe wrote:
> > On Fri, 2019-07-12 at 18:08 +, Chatterjee, Shibayan wrote:
> > > > Jul 12 10:00:51 postgresql-check-db-dir: "/data/postgresql/data" is
> > > > missing or empty.
> > > > Jul 12 10:00:51 postgresql-check-db-dir: Use "postgresql-s
On Sun, Jul 14, 2019 at 5:05 PM Laurenz Albe wrote:
> Since you say that there was a regular data directory there, that would point
> to permission problems.
I'm not a systemd expert, but since we are _before_ starting the
cluster, the checks should be run as superuser, so I don't see how a
permi
On Fri, Jul 12, 2019 at 4:34 PM Nicola Contu wrote:
> P.S.: I am on postgres 11.3
>
> Il giorno ven 12 lug 2019 alle ore 16:32 Nicola Contu <
> nicola.co...@gmail.com> ha scritto:
>
>> Hello,
>> we noticed with a simple matview we have that refreshing it using the
>> concurrently item the space a
It does not. That's the issue.
It always increases of 120mb and it reached 12gb instead of just 180mb.
Il dom 14 lug 2019, 21:34 Kaixi Luo ha scritto:
>
> On Fri, Jul 12, 2019 at 4:34 PM Nicola Contu
> wrote:
>
>> P.S.: I am on postgres 11.3
>>
>> Il giorno ven 12 lug 2019 alle ore 16:32 Nicola
[ please do not top-post in your replies, it makes the conversation hard
to follow ]
Nicola Contu writes:
> Il dom 14 lug 2019, 21:34 Kaixi Luo ha scritto:
>> This is normal and something to be expected. When refreshing the
>> materialized view, the new data is written to a disk and then the t
Could I use the following in psql or in a sql :
"D:\PostgreSQL\9.6\bin\pgsql2shp "
thanks
peng
On 7/14/19 10:54 PM, sunpeng wrote:
Could I use the following in psql or in a sql :
"D:\PostgreSQL\9.6\bin\pgsql2shp "
This *should* work, though you might have to fiddle with the quotes:
yourdb=> \! "D:\PostgreSQL\9.6\bin\pgsql2shp "
--
Angular momentum makes the world go 'round.
On 7/14/19 8:54 PM, sunpeng wrote:
Could I use the following in psql or in a sql :
"D:\PostgreSQL\9.6\bin\pgsql2shp "
It's a command line program. See the docs:
https://postgis.net/docs/using_postgis_dbmanagement.html
4.5.2. Using the Dumper
The pgsql2shp table dumper connects directly t
On Fri, Jul 12, 2019 at 12:04 PM Luca Ferrari wrote:
> Since tables are unlogged, I was expecting no much difference in
> setting checkpoint_completion_target, but I got (average results):
> - checkpoint_completion_target = 0.1 ==> 755 tps
> - checkpoint_completation_target = 0.5 ==> 767 tps
> -
