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
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.
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 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
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
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-
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
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
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
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 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 '
D'oh. Thanks!
/--\
| Tel: (630) 840 5005|
| FAX: (630) 840 2968|
|(630) 840 2783|
| office:FCC 240
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,
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
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 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
>
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
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
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
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
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/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
> 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
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
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,
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.
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 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
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
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
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
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 -
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
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
>-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
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/
37 matches
Mail list logo
