Hi Dimiry,
On 04/06/2019 23:49, Dmitry O Litvintsev wrote:
> Where can I find postgresq11-devel RPM ?
> [...]
> https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/
have you looked under the letter "P" in your first link?
There you can find the -devel package.
https://yum.postgresql.org/
>-Original Message-
>From: David Rowley
>Sent: 05 June 2019 01:48
>To: Rob Northcott
>Cc: pgsql-general@lists.postgresql.org
>Subject: Re: Query very different speeds on seemingly similar data
>On Wed, 5 Jun 2019 at 04:55, Rob Northcott
>wrote:
>> Explain files attached (assuming at
Chris Withers wrote:
> Is there any way to grant rights to a user such that they can drop and
> re-create only a single database?
No; what I'd do if I needed that is to create a SECURITY DEFINER function
that is owned by a user with the CREATEDB privilege.
This function can be called by a normal
On 05/06/2019 09:52, Laurenz Albe wrote:
Chris Withers wrote:
Is there any way to grant rights to a user such that they can drop and
re-create only a single database?
No; what I'd do if I needed that is to create a SECURITY DEFINER function
that is owned by a user with the CREATEDB privilege.
T
On 6/4/19 6:24 PM, Laurenz Albe wrote:
Tomasz Ostrowski wrote:
The TCP keepalives functionality on the database server's operating
system would figure out that the connection is not working anymore and
close it.
You'd assume that the database would get the info and cancel the query.
Except -
Hi Team,
While during the pg_repack installation getting below error please someone
help
postg...@brurhen001.enterprisenet.org:
/home/postgres/software/pg_repack-1.4.4
==> ll
total 16
drwx--. 3 postgres postgres 71 Oct 18 2018 bin
-rw---. 1 postgres postgres 1662 Oct 18 2018 COPYRIGHT
Tomasz Ostrowski wrote:
> The database would get an error on the connection socket only after it tries
> to read or write to it next time. But it does not try to do this - it's busy
> counting those quarks until statement_timeout is reached.
>
It is unfortunate that PostgreSQL does not take i
On 2019-06-05 12:48, Prakash Ramakrishnan wrote:
> gcc -Wall -Wmissing-prototypes -Wpointer-arith
> -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
> -Wformat-security -fno-strict-aliasing -fwrapv
> -fexcess-precision=standard -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2
> -fe
Hi Peter,
Thanks i have successfully created the extension how to use full vacuum
using pg_repack.
Regards,
Prakash.R
On Wed, Jun 5, 2019 at 5:23 PM Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> wrote:
> On 2019-06-05 12:48, Prakash Ramakrishnan wrote:
> > gcc -Wall -Wmissing-prototypes
El día Tuesday, June 04, 2019 a las 07:20:54PM +0200, Matthias Apitz escribió:
> El día Tuesday, June 04, 2019 a las 05:56:49PM +0100, Andrew Gierth escribió:
>
> > If you use COPY ... WITH DELIMITER '|' (i.e. text mode, not CSV mode)
> > then the \| is accepted as being a literal | and the unesc
Hi,
I’m using Postgresql 11.3 on Centos 7.6.18.10 server.
I have very unusual issue which I don’t know if it is OK:
I have running postgresql server with default instance:
[root@pgpmaster ~]# systemctl status postgresql-11
● postgresql-11.service - PostgreSQL 11 database server
Loaded: loaded
Hi Prakash,
You can run below command.
pg_repack -d dbname -E DEBUG
On Wed, Jun 5, 2019, 7:55 PM Prakash Ramakrishnan <
prakash.ramakrishnan...@nielsen.com> wrote:
> Hi Peter,
>
> Thanks i have successfully created the extension how to use full vacuum
> using pg_repack.
>
> Regards,
> Prakash.
Hi Sathish,
Thanks for quick response and the database using separate table-space and
we need to clear table and index bloat values and using jobs also how can i
achieve this need exact command ?
Regards,
Prakash.R
On Wed, Jun 5, 2019 at 6:16 PM Sathish Kumar wrote:
> Hi Prakash,
>
> You can r
Hi Prakash,
You can see all the available options from here.
http://reorg.github.io/pg_repack/#installation
On Wed, Jun 5, 2019, 8:48 PM Prakash Ramakrishnan <
prakash.ramakrishnan...@nielsen.com> wrote:
> Hi Sathish,
>
> Thanks for quick response and the database using separate table-space and
> Tomasz Ostrowski wrote:
>
>> The database would get an error on the connection socket only after it tries
>> to read or write to it next time. But it does not try to do this - it's busy
>> counting those quarks until statement_timeout is reached.
>>
>
I found relevant patch from postgresp
On 6/5/19 5:46 AM, Domen Šetar wrote:
Hi,
I’m using Postgresql 11.3 on Centos 7.6.18.10 server.
I have very unusual issue which I don’t know if it is OK:
I have running postgresql server with default instance:
[root@pgpmaster ~]# systemctl status postgresql-11
● postgresql-11.service - Postg
Hi Sathish,
Thanks i ran the pg_repack and its working fine but still the wasted bytes
not removing why?
current_database | schemaname |tablename
| tbloat | wastedbytes | i
name | ibloat |
On 6/4/19 7:27 PM, Ron wrote:
On 6/4/19 7:19 PM, Adrian Klaver wrote:
On 6/4/19 3:29 PM, Lou wrote:
Hi everyone,
Is it possible to convert a boolean yes or no field to hold a one
letter string? For example, the strings: 's' 'f' 'p' 'e'
To start off, I just need to convert true to 's'. fal
On 5/6/19 3:46 μ.μ., Domen Šetar wrote:
Hi,
I’m using Postgresql 11.3 on Centos 7.6.18.10 server.
I have very unusual issue which I don’t know if it is OK:
I have running postgresql server with default instance:
[root@pgpmaster ~]# systemctl status postgresql-11
● postgresql-11.service - Po
Dear all,
I cannot find documentation on whether
CREATE DATABASE ... TEMPLATE template_db;
will verify checksums (if enabled) on template_db during
reading.
I would assume it does not, because very likely the copy
process happens at the file level. Is that correct ?
Many thanks,
Karste
Hello Experts,
Is it possible to configure multiple backup repositories in pgbackrest tool
in one server?
I am getting few issues with that.
--
*Regards,#! Pavan Kumar--*-
*Sr. Database Administrator..!*
*NEXT GENERATION PROFESSIONALS, LLC*
*Cell
On Wed, Jun 5, 2019 at 4:47 PM Karsten Hilbert
wrote:
> Dear all,
>
> I cannot find documentation on whether
>
> CREATE DATABASE ... TEMPLATE template_db;
>
> will verify checksums (if enabled) on template_db during
> reading.
>
> I would assume it does not, because very likely the copy
>
Chris Withers wrote:
> > > Is there any way to grant rights to a user such that they can drop and
> > > re-create only a single database?
> > No; what I'd do if I needed that is to create a SECURITY DEFINER function
> > that is owned by a user with the CREATEDB privilege.
>
> Thanks, that's a great
On 6/5/19 9:48 AM, Pavan Kumar wrote:
Hello Experts,
Is it possible to configure multiple backup repositories in pgbackrest
tool in one server?
I am getting few issues with that.
https://pgbackrest.org/command.html#command-backup
3.4.9
Repository Path Option (--repo-path)
Path where backu
The documentation in CREATE FUNCTION is fine as far is it goes regarding the
COST setting, but that isn’t very far, and I haven’t had any luck finding good
advice.
How do I determine what value to set as the COST of a function? I understand
that it’s a relative, abstract, per-row sort of thing,
D'oh. Thanks!
/--\
| Tel: (630) 840 5005|
| FAX: (630) 840 2968|
|(630) 840 2783|
| office:FCC 240
On Tue, 4 Jun 2019 at 18:30, Lou wrote:
> Hi everyone,
>
> Is it possible to convert a boolean yes or no field to hold a one letter
> string? For example, the strings: 's' 'f' 'p' 'e'
>
> To start off, I just need to convert true to 's'. false will have to be
> manually changed to 'f' or 'p' or '
Hi All,
We have recently noticed in our development environment pg_log with flooded
message.
[64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:
pg_getnameinfo_all() failed: Temporary failure in name resolution
[64463]: [1-1] user=[unknown],db=[unknown],host= WARNING:
pg_getnameinfo_all()
On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj wrote:
> Hi All,
>
> We have recently noticed in our development environment pg_log with
> flooded message.
>
> [64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:
> pg_getnameinfo_all() failed: Temporary failure in name resolution...
>
First th
Hello Ron,
Thank you so much for quick response.
here is my configuration.
[postgres@oralnx v2demo4448]$cat /etc/pgbackrest/pgbackrest.conf
[v1demo]
pg1-path=/oradbaudit/pg_data_dir
pg1-port=5400
[v2demo]
pg1-path=/oratrace/11_2_data
pg1-port=4448
# Backup repository configuration
[global]
repo
Greetings,
(dropping -admin, please do NOT send to multiple mailing lists- just
pick one)
* Pavan Kumar (pavan.db...@gmail.com) wrote:
> Is it possible to configure multiple backup repositories in pgbackrest tool
> in one server?
While we have considered adding support for that, it's not there t
You set pg1-path and pg1-port in both v1demo and v2demo. Shouldn't v2demo
use pg2-path and pg2-port?
On 6/5/19 2:43 PM, Pavan Kumar wrote:
Hello Ron,
Thank you so much for quick response.
here is my configuration.
[postgres@oralnx v2demo4448]$cat /etc/pgbackrest/pgbackrest.conf
[v1demo]
pg1-
On Wed, Jun 5, 2019 at 11:08 AM Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On Wed, Jun 5, 2019 at 10:13 AM Perumal Raj wrote:
>
>>
>> [64459]: [1-1] user=[unknown],db=[unknown],host= WARNING:
>> pg_getnameinfo_all() failed: Temporary failure in name resolution...
>>
>
> First thin
Hi team,
anyone? Please let me know if this is not a correct group to ask, I'll move it
somewhere else.
Thank you in advance & Kind Regards,
Jan
On 2019-06-04 08:56:47+10:00 Jan Bilek wrote:
Hi,
We've build a Payments Authorisation system (Box solution) on Postgresql
database and now we are
Thanks Steve for the response, Yes we had DNS server change.
But conf file updated with right DNS server and its resolving when i
crosscheck with nslookup against clinet_addr
By the way , What is the right syntax for LDAP configuration ,
I am using the one below, and getting LDAP authentication e
Hi
čt 6. 6. 2019 v 1:23 odesílatel Jan Bilek napsal:
> Hi team,
>
> anyone? Please let me know if this is not a correct group to ask, I'll
> move it somewhere else.
>
this question, proposal is much more related to pgsql-hackers forum.
Currently Postgres doesn't support any feature like this.
Postgres has spent several decades creating a data store that does its best
to make sure data is accessible and never accidentally lost. The cobc8of a
secure forensic wipe is anathama to the product goals. To have any hope of
implementing such a thing with confidence you'd need to drop most of thos
37 matches
Mail list logo
