Hi, ALL,
I tried to follow an instructions at
https://www.postgresql.org/ftp/binary/v9.6.1/solaris/solaris11/i386/
in the README but I received following:
[code]
igor@solaris:/usr$ sudo bunzip2 < postgresql-9.6.1-S11.i386-64.tar.bz2
| tar xpf -
tar: postgres: Permission denied
tar: postgres:
Jeff Janes writes:
> On Fri, Mar 22, 2019 at 8:04 AM Steve Atkins wrote:
>
>>
>>
>> > On Mar 22, 2019, at 10:56 AM, Christian Henz
>> wrote:
>> >
>>
>> There's the BigSQL fork, which had at least some minimal support
>> for 10. I've no idea whether it's had / needs anything for 11
>
>
> I
Hi!
Or, if you want to check/enforce this from the server side,
you could enable log_connections and see what's logged;
or simply change pg_hba.conf to disallow non-SSL connections.
I set log_connections =on
pg_hba.conf contains :
local all postgres
On Fri, Mar 22, 2019 at 12:26:33PM -0400, Jeff Janes wrote:
> archive_cleanup_command is pretty much obsolete. The modern way to do this
> is with streaming replication, using either replication slots or
> wal_keep_segments. If the only reason you want an archive is for
> replication, then use
On Fri, Mar 22, 2019 at 12:07:27PM +0300, Ali Mumcu wrote:
> when on master create new wal_file(like *00010009)* and
> then on slave this is updating on slave like "*startup recovering
> 00010009* "
>
> Is that a problem or not i dont know?
That's normal.
On Fri, Mar 22, 2019 at 8:04 AM Steve Atkins wrote:
>
>
> > On Mar 22, 2019, at 10:56 AM, Christian Henz
> wrote:
> >
>
> There's the BigSQL fork, which had at least some minimal support
> for 10. I've no idea whether it's had / needs anything for 11
I just installed BigSQL's v11 of the
You could try OmniDB, is web app but have a version that just feels like a
desktop application. Is supported by 2ndQuadrant.
This is the official website https://omnidb.org/en/
Greetings
El vie., 22 mar. 2019 a las 4:56, Christian Henz ()
escribió:
> I know I'm late to the party, but we're
On 2019-03-22 13:40:28 +0100, Francisco Olarte wrote:
> On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
> wrote:
> > Thank you for asking several times for a benchmark.
> > I wrote it now and it is visible: inserting random bytes into bytea
> > is much slower, if you use the psycopg2 defaults.
>
On version 10 and 11 hash index was redesigned and now seems to be better
than btree.
Their speed, size and memory consuption are better, so ...
Why is not possible to have all PK and FK just using hash indices ? The only
thing I need on a PK and FK is search and join, so hash index responds
On Fri, Mar 22, 2019 at 9:55 PM wrote:
> This is probably my 10th attempt to move from pgadminIII to pgadmin4. At
> least the performance has significantly improved over time and seems now
> acceptable.
>
> The biggest drawback is however that all elements are locked up in one
> browser window –
Thomas:
On Fri, Mar 22, 2019 at 2:03 PM Thomas Güttler
wrote:
> > I'm not too sure, but I read ( in the code ) you are measuring a
> > nearly not compressible urandom data againtst a highly compressible (
...
> for this case toast-tables/wal is a detail of the implementation.
> This tests does
Not sure I understand the issue. On Ubuntu every time I open pgAdmin4, it
opens up a new tab on the browser. If it's not in a separate browser
window, just drag the tab out and Firefox at least will open a new browser
window.
I have 3 pgA4 windows open right now.
Maybe I am missing the point,
On Fri, Mar 22, 2019 at 6:28 AM Foo Bar wrote:
>
> Fast forward two weeks, this cluster has been running but not seeing any
> traffic. And my master server has filled its archive directory.
>
Are you sure it is the archive directory (/hab/svc/postgresql/data/archive)
which is filling up, and
This is probably my 10th attempt to move from pgadminIII to pgadmin4. At least
the performance has significantly improved over time and seems now acceptable.
The biggest drawback is however that all elements are locked up in one browser
window – I cannot find any option to detach a query
"Andrus" writes:
> log file does not show ssl connection info:
> 2019-03-22 16:49:03 EET [unknown] [unknown] LOG:
> connection received: host=xx.xx.xx.xx port=54590
> 2019-03-22 16:49:04 EET testuseryle LOG: connection
> authorized: user=testuser
Or just persevere with pgadmin4 for a few months? Pretty common for
people to hate any major changes to a tool that they are very comfortable
with.
This year I've invested the time to learn a few new toolsets (not on
Postgresql necessarily) and found it to be well worth while.
At least
On 3/21/19 11:51 AM, Foo Bar wrote:
Hello,
We're evaluating PostgreSQL for use with Artifactory in our
environment. PostgreSQL seems like the obvious choice because it
provides hot-standby replication. I've followed several guides I've
found by googling "postgres replication how to" (i.e.:
On 3/22/19 2:00 AM, Andrus wrote:
Hi!
Old Postgres
"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"
Server has symlinks server.crt and server.key in data directory
/var/lib/postgresql/9.1./main and ssl=true in postgresql.conf file.
"Andrus" writes:
> Client accesses server from Windows 10 using psqlODBC driver with
> sslmode=allow in connection string.
> How to verify that connection is encrypted ?
When using libpq directly, you could use PQsslInUse(),
or PQsslAttribute() for more detailed info. I'm not
sure if ODBC
Am 22.03.19 um 13:40 schrieb Francisco Olarte:
Thomas:
On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
wrote:
Thank you for asking several times for a benchmark.
I wrote it now and it is visible: inserting random bytes into bytea is much
slower,
if you use the psycopg2 defaults.
Here is
On Fri, Mar 22, 2019 at 01:40:28PM +0100, Francisco Olarte wrote:
> Thomas:
>
> On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
> wrote:
> > Thank you for asking several times for a benchmark.
> > I wrote it now and it is visible: inserting random bytes into bytea is much
> > slower,
> > if you
Thomas:
On Fri, Mar 22, 2019 at 11:22 AM Thomas Güttler
wrote:
> Thank you for asking several times for a benchmark.
> I wrote it now and it is visible: inserting random bytes into bytea is much
> slower,
> if you use the psycopg2 defaults.
> Here is the chart:
>
>
> On Mar 22, 2019, at 10:56 AM, Christian Henz
> wrote:
>
> I know I'm late to the party, but we're only now migrating from
> Postgres 9.x, realizing that pgadmin3 does not support Postgres 11.
>
> I have checked out pgadmin4, but I don't like it at all. My colleagues
> feel the same way,
I know I'm late to the party, but we're only now migrating from
Postgres 9.x, realizing that pgadmin3 does not support Postgres 11.
I have checked out pgadmin4, but I don't like it at all. My colleagues
feel the same way, and some web searching suggests that we are not
alone.
So I wonder if
pá 22. 3. 2019 v 10:49 odesílatel Aleš Zelený
napsal:
> Hello,
>
> I've learned that logical replication might have performance problem if
> there are lot of sub transactions within transaction (at least because it
> enforces spill files in pg_replslot and if there are many - like 80mio,
> EXT4
Hi!
Old Postgres
"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real
(Debian 4.4.5-8) 4.4.5, 64-bit"
Server has symlinks server.crt and server.key in data directory
/var/lib/postgresql/9.1./main and ssl=true in postgresql.conf file.
Server is running in old Debian
Hello,
We're evaluating PostgreSQL for use with Artifactory in our environment.
PostgreSQL seems like the obvious choice because it provides hot-standby
replication. I've followed several guides I've found by googling "postgres
replication how to" (i.e.: this one from DigitalOcean
On Fri, 22 Mar 2019 at 19:13, Павлухин Иван wrote:
> I am learning deeply how tuples are organized and column values are
> accessed in different databases. As far as undertood postgres does not
> store all column positions in a tuple (e.g. in header or footer). In
> contrast MySQL InnoDB stores
Hello,
I've learned that logical replication might have performance problem if
there are lot of sub transactions within transaction (at least because it
enforces spill files in pg_replslot and if there are many - like 80mio,
EXT4 did not perform well - in my case it was caused bu misuse of
Also this is postgresql Log(Debug1 level) . after i restart slave node this
logs accours.
/var/lib/pgsql/11/data/log/postgresql-Fri.log
2019-03-22 12:17:57.869 +03 [31760] LOG: redo starts at 0/C98
2019-03-22 12:17:57.869 +03 [31760] LOG: consistent recovery state reached
at 0/CD0
Hello Friends,
I wanna to create Streaming Replication with 2 Node(1 Master, 1 Slave)
After i create streaming replication, streaming is okay , and than when i
add new record on master , than on slave records occurs autamaticly.
but When i look service status on slave server i "see startup
Hi PostgreSQL Community,
I am learning deeply how tuples are organized and column values are
accessed in different databases. As far as undertood postgres does not
store all column positions in a tuple (e.g. in header or footer). In
contrast MySQL InnoDB stores column lengths in a record header
32 matches
Mail list logo