From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Melvin Davidson
Sent: Wednesday, October 19, 2016 5:35 PM
To: Alex Ignatov (postgrespro)
Cc: Tom Lane ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
On Wed, Oct
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Tom Lane
Sent: Wednesday, October 19, 2016 4:31 PM
To: Alex Ignatov (postgrespro)
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
"Alex Ig
rotected by any checksums in minds. Youl never know that PG clog is corrupted
until "doomsday"
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Thomas Kellerer
Sent: Wednesday, October 19, 2016 1:53 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Drop user cascade
Alex Ignatov (postgrespro) schrieb am
Hello!
Why we can DROP TABLE CASCADE, DROP VIEW CASCADE, DROP SEQUENCE CASCADE but
we can't DROP USER/ROLE CASCADE?
Why do Postgres have no such functionality as DROP USER CASCADE? Is there
any reasons in that absence?
--
Alex Ignatov
Postgres Professional:
(PID 20397) was terminated by signal 11: Segmentation fault
Well, as I told you, get a stack trace with debugging symbols.
Yours,
Laurenz Albe
Hi!
May be this helps:
"Don't add oracle_fdw to shared_preload_libraries! (c) Laurenz Albe
Alex Ignatov
Postgres Prof
Hi! Make trigger function
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
On Fri, Aug 5, 2016 at 10:25 PM +0300, "Christian Ohler"
wrote:
Hi,
I'm trying to find a way to have Postgres tell me if the current transactio
On 05.08.2016 18:54, Tom Lane wrote:
Alex Ignatov writes:
On 05.08.2016 17:51, Tom Lane wrote:
Sure. Just like it reserves space for ordinary tables right away,
long before there's any need to push the data out of shared_buffers.
Otherwise, you might find yourself having to throw an &q
tion? With
this preliminary reservation we use HDD resource but in fact we dont
need it.
In situation with high rate creation of temp table, we saturate HDD
resource with "just in case" reservation.
Have we any other explanation except "out of space" problem? May be
there i
different?
3. How do you check timezone equivalence between master and slave? What
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 04.08.2016 05:21, Patrick B wrote:
Hi all,
I'm currently using PostgreSQL 9.2. I noticed that the wal_files are
On 28.07.2016 19:43, Scott Marlowe wrote:
On Thu, Jul 28, 2016 at 10:32 AM, Alex Ignatov wrote:
Oh, so in contrast to "Oracle world" "Postgres world" DBA in their right
to do major upgrade without complete and tested backup?
Ok, I understand you. In Postgres world ther
On 28.07.2016 18:41, Igor Neyman wrote:
-Original Message-
From: Alex Ignatov [mailto:a.igna...@postgrespro.ru]
Sent: Thursday, July 28, 2016 11:26 AM
To: Igor Neyman ; Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber migrated from Postgres to MySQL
On 28.07.2016 18
On 28.07.2016 18:09, Igor Neyman wrote:
-Original Message-
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Alex Ignatov
Sent: Thursday, July 28, 2016 10:59 AM
To: Rakesh Kumar
Cc: PostgreSQL General
Subject: Re: [GENERAL] Uber
On 28.07.2016 17:50, Rakesh Kumar wrote:
On Thu, Jul 28, 2016 at 10:38 AM, Alex Ignatov wrote:
Sorry, what? You can rollback to previous version of software what you had.
https://docs.oracle.com/cd/E11882_01/server.112/e23633/downgrade.htm#UPGRD007
Not so fast. This requires the db to be
minor version upgrade. Major version upgrade almost
definitely involves change in transaction log
(WAL) structure and hence no rollback.
Sorry, what? You can rollback to previous version of software what you had.
https://docs.oracle.com/cd/E11882_01/server.112/e23633/downgrade.htm#UPGRD007
revoke usage on language plpythonu from username;
revoke usage on language plperl(u) from username;
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 26.07.2016 16:05, David G. Johnston wrote:
On Tue, Jul 26, 2016 at 8:53 AM, Dev Kumkar
Ok, thanks !
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 22.07.2016 06:49, Sameer Kumar wrote:
On Thu, Jul 21, 2016 at 7:14 PM Alex Ignatov <mailto:a.igna...@postgrespro.ru>> wrote:
And what is the options you mentioned a
And what is the options you mentioned about?
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 20.07.2016 21:02, Sameer Kumar wrote:
On Thu, 21 Jul 2016, 1:17 a.m. Alex Ignatov, <mailto:a.igna...@postgrespro.ru>> wrote:
Hello
Hello everyone!
Is there any way to make pg_dump(9.5) to dump table (with data) without
any SET command in the header of output plain sql file?
P.S. Yeah I know about sedding =)
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via
checksums on clog's file. So if any
corruption is happend in this file you also will never know it.
So at now pg_basebackup+ wal archiving is like walking on the minefield
with tightly closed eyes . You never know when it will make explode!
Alex Ignatov
Postgres Professional: http://w
c). Also
what file system Postgresql data dir is using?
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
ECK constraints on the children and can't do it if the child is locked
in ACCESS EXCLUSIVE mode.
+1
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
Hello!
Can I list all WAL files in pg_xlog by using some sql query in Postgres?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 31.05.2016 0:12, Alex Ignatov wrote:
_
From: David G. Johnston <mailto:david.g.johns...@gmail.com>>
Sent: Monday, May 30, 2016 23:44
Subject: Re: [GENERAL] Si
_
From: David G. Johnston
Sent: Monday, May 30, 2016 23:44
Subject: Re: [GENERAL] Silent data loss in its pure form
To: Alex Ignatov
Cc: , Scott Marlowe
On Mon, May 30, 2016 at 4:22 PM, Alex Ignatov wrote:
_
From: Scott
_
From: Scott Marlowe
Sent: Monday, May 30, 2016 20:14
Subject: Re: [GENERAL] Silent data loss in its pure form
To: Alex Ignatov
Cc:
On Mon, May 30, 2016 at 10:57 AM, Alex Ignatov wrote:
> Following this bug reports from redhat
> https://bugzilla.redh
good data.
Keep in mind it while checking you "backups" in any forms (pg_dump or
the more dangerous and short-spoken PITR file backup)
You data is always in danger with "zeroed data file is normal file"
paradigm.
--
Alex Ignatov
Postgres Professional: http://www.postgre
you fall it some issues with "file not exist" and other.
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
ileid" from
outer query
LINE 3: where id = substring(fileid from -1)
but the following query:
SELECT (select msc_id
from collectors
where id = fileid
) msc_id
from ip_data_records
group by fileid
is working ok?
--
Alex Ignato
2;
REVOKE
postgres=> revoke select(i2) on table user1.t2 from user2;
REVOKE
postgres=> revoke select(i2) on table user1.t2 from user2;
REVOKE
No warnings about that this grant is not available.
It looks like revoking nonexisting grants is allowed???
--
Alex Ignatov
Postgres Pro
Use pgbouncer between app server and Postgres =)
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s 100% but sum from first can be != 100%? First column is the %
of time when child function(procedure) is working relative to main proc
time.
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-ge
in details?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 21.04.2016 20:26, Vick Khera wrote:
On Thu, Apr 21, 2016 at 9:00 AM, Alex Ignatov
mailto:a.igna...@postgrespro.ru>> wrote:
Ms Windows doesnt have ZFS support. AIX also doesnt. Z/OS also.
Any other commercial Linux distros don't have ZFS support. Yes you
can com
On 20.04.2016 23:28, Vick Khera wrote:
On Wed, Apr 20, 2016 at 3:43 AM, Alex Ignatov
mailto:a.igna...@postgrespro.ru>> wrote:
What do you think about defaulting --data-checksums in initdb?
I think that ZFS storing my database files already does this and can
correct for it
On 20.04.2016 16:58, Alvaro Herrera wrote:
Alex Ignatov wrote:
Hello everyone!
Today in Big Data epoch silent data corruption becoming more and more issue
to afraid of. With uncorrectable read error rate ~ 10^-15 on multiterabyte
disk bit rot is the real issue.
I think that today
On 20.04.2016 12:27, Andreas Joseph Krogh wrote:
På onsdag 20. april 2016 kl. 11:22:33, skrev Alex Ignatov
mailto:a.igna...@postgrespro.ru>>:
[snip]
Why do you think that common pg-users doesn't care about their data?
Did I say that?
Also why do we have wal_level=mi
On 20.04.2016 12:10, Andreas Joseph Krogh wrote:
På onsdag 20. april 2016 kl. 11:02:31, skrev Alex Ignatov
mailto:a.igna...@postgrespro.ru>>:
On 20.04.2016 11:40, Andreas Joseph Krogh wrote:
På onsdag 20. april 2016 kl. 10:33:14, skrev Alex Ignatov
mailto:
On 20.04.2016 11:40, Andreas Joseph Krogh wrote:
På onsdag 20. april 2016 kl. 10:33:14, skrev Alex Ignatov
mailto:a.igna...@postgrespro.ru>>:
On 20.04.2016 11:29, Devrim Gündüz wrote:
> Hi,
>
> On Wed, 2016-04-20 at 10:43 +0300, Alex Ignatov wrote:
>&
On 20.04.2016 11:29, Devrim Gündüz wrote:
Hi,
On Wed, 2016-04-20 at 10:43 +0300, Alex Ignatov wrote:
Today in Big Data epoch silent data corruption becoming more and more
issue to afraid of. With uncorrectable read error rate ~ 10^-15 on
multiterabyte disk bit rot is the real issue.
I think
On 20.04.2016 10:58, Michael Paquier wrote:
On Wed, Apr 20, 2016 at 4:43 PM, Alex Ignatov wrote:
Hello everyone!
Today in Big Data epoch silent data corruption becoming more and more issue
to afraid of. With uncorrectable read error rate ~ 10^-15 on multiterabyte
disk bit rot is the real
On 20.04.2016 10:47, John R Pierce wrote:
On 4/20/2016 12:43 AM, Alex Ignatov wrote:
Today in Big Data epoch silent data corruption becoming more and more
issue to afraid of. With uncorrectable read error rate ~ 10^-15on
multiterabyte disk bit rot is the real issue.
are not those
doesn't care about his data he can manually turn this
option off.
What do you think about defaulting --data-checksums in initdb?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
On 13.04.2016 18:40, Alex Ignatov wrote:
On 13.04.2016 17:26, Adrian Klaver wrote:
On 04/13/2016 04:16 AM, Alex Ignatov wrote:
On 12.04.2016 20:50, Tom Lane wrote:
Alex Ignatov writes:
You always should keep in mind that your application may run in test
mode (future/past time) and
On 13.04.2016 17:26, Adrian Klaver wrote:
On 04/13/2016 04:16 AM, Alex Ignatov wrote:
On 12.04.2016 20:50, Tom Lane wrote:
Alex Ignatov writes:
You always should keep in mind that your application may run in test
mode (future/past time) and maintain this code. While with my proposal
you
ours';
SET
regression=# select timeofday();
timeofday
--
Sun Apr 17 18:01:58.293623 2016 +120
(1 row)
regards, tom lane
Oh!
This is better than nothing =)!
--
Alex Ignatov
Postgres Professional: http://www.post
On 12.04.2016 20:50, Tom Lane wrote:
Alex Ignatov writes:
You always should keep in mind that your application may run in test
mode (future/past time) and maintain this code. While with my proposal
you can always use some time function(now or localtimestamp or
whatever) which you can
On 12.04.2016 19:45, David G. Johnston wrote:
On Tue, Apr 12, 2016 at 8:37 AM, Alex Ignatov
mailto:a.igna...@postgrespro.ru>>wrote:
On 12.04.2016 18:01, Adrian Klaver wrote:
>>I do it by having the date be one of the function arguments and
have the default be so
On 12.04.2016 18:01, Adrian Klaver wrote:
On 04/12/2016 07:36 AM, Alex Ignatov wrote:
On 12.04.2016 16:57, George Neuner wrote:
On Tue, 12 Apr 2016 13:50:11 +0300, Alex Ignatov
wrote:
Is there any method to freeze localtimestamp and other time function
value.
Say after freezing on some
On 12.04.2016 16:57, George Neuner wrote:
On Tue, 12 Apr 2016 13:50:11 +0300, Alex Ignatov
wrote:
Is there any method to freeze localtimestamp and other time function value.
Say after freezing on some value sequential calls to these functions
give you the same value over and over again.
This
On 12.04.2016 15:13, Rakesh Kumar wrote:
I think PG does fixed time within a tran. check the output of the following sql
begin;
select now() ;
select pg_sleep(10);
select now() ;
commit;
select now() ;
select pg_sleep(10);
select now() ;
~
On Tue, Apr 12, 2016 at 6:50 AM, Alex Ignatov wrote
. Have Postgres
this functionality?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 07.04.2016 17:59, Rob Sargent wrote:
On Apr 7, 2016, at 8:26 AM, Alex Ignatov wrote:
On 07.04.2016 16:53, Tom Lane wrote:
Alex Ignatov writes:
My question is: is there any option(s) to log non-default
postgresql.conf values to log file?
No, but you can easily find all the non
On 07.04.2016 16:53, Tom Lane wrote:
Alex Ignatov writes:
My question is: is there any option(s) to log non-default
postgresql.conf values to log file?
No, but you can easily find all the non-default settings by querying
the pg_settings view.
regards, tom lane
= "/ora/oradata/orcl/control01.ctl"
...
My question is: is there any option(s) to log non-default
postgresql.conf values to log file?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@post
, margrit drescher wrote:
I originally used the 9.4.6 version on
http://www.enterprisedb.com/products-services-training/pgdownload#windows
for 64-bit windows and loaded the language pack recommended in the
readme file.
On 31 March 2016 at 11:25, Alex Ignatov-2 [via PostgreSQL] <[hidden
em
stgresql.nabble.com/Postgres-9-4-4-9-4-6-plpython2-3-intallation-issues-on-a-Windows-7-machine-tp5896157.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Hello!
What postgres distr for Win are you using?
--
Alex Ignatov
Postgres Professional: http://www.post
> On 04 Mar 2016, at 21:08, Tom Lane wrote:
>
> Alex Ignatov writes:
>> Why string literal like 'Hello world!' doesnt automagicaly cast to text
>> type?
>
> Because it's not necessarily a string. It might be meant to be point,
> or json, or
generally o/s agnostic.
>
>>> On Fri, Mar 4, 2016 at 12:17 PM, Alex Ignatov
>>> wrote:
>>> Hello!
>>> Why string literal like 'Hello world!' doesnt automagicaly cast to text
>>> type?
>>>
>>>
>>> But why we don
Oh! Great answer! Thats what i want to know!!!
Thank you Pavel about explanation!!!
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
Russian Postgres Company
> On 04 Mar 2016, at 20:45, Pavel Stehule wrote:
>
> Hi
>
> 2016-03-04 18:29 GMT+01:00 Melvin Davidso
t by default in Postgres? Is there
any fundamental restriction on that or there is some reasons for that?
--
Alex Ignatov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
61 matches
Mail list logo
