Hi,
If have a view that I would like to sort where I divide the return in 3
different groups.
These 3 groups then should have a random sort order each.
As I am I using it with an offset, and limit, the randomness should be the
same.
For example:
SELECT user_id, age FROM view_users
ORDER BY CASE
o now neither site will start
1) how . what steps do I need to do to fix this - with out just adding
space !
2) how do I stop this from happening - i think the space being used up is
the repmgr stats page - i think - will not know till I can get the servers
back up
Alex
On 16 August 2017 at 20:55, Achilleas Mantzios wrote:
> On 16/08/2017 13:46, Alex Samad wrote:
>
>
>
> On 16 August 2017 at 16:16, Michael Paquier
> wrote:
>
>> On Wed, Aug 16, 2017 at 2:32 PM, Alex Samad wrote:
>> > 1) why did it fill up this tim
On 17 August 2017 at 10:51, Ian Barwick wrote:
> On 08/16/2017 02:41 PM, Alex Samad wrote:
> (...)
> >
> > okay think I have it setup, but when i do a switch over it gets stuck
> here.
> >
> >
> >
> > NOTICE: STANDBY PROMOTE successful
> &g
Great I will add it to my notes.
Thanks
On 16 August 2017 at 20:55, Achilleas Mantzios wrote:
> On 16/08/2017 13:46, Alex Samad wrote:
>
>
>
> On 16 August 2017 at 16:16, Michael Paquier
> wrote:
>
>> On Wed, Aug 16, 2017 at 2:32 PM, Alex Samad wrote:
>> >
On 16 August 2017 at 16:16, Michael Paquier
wrote:
> On Wed, Aug 16, 2017 at 2:32 PM, Alex Samad wrote:
> > 1) why did it fill up this time and not previously
> > I add this
> > archive_command = '/bin/true'
> > wal_keep_segments = 1000 # <<< I&
On 15 August 2017 at 16:35, Andreas Kretschmer
wrote:
>
>
> Am 15.08.2017 um 05:15 schrieb Alex Samad:
>
>> Hi
>>
>> Quick question. I have a 2 node cluster - each node has its own ip.
>>
>> But from reading this, I really need a 3rd ip, which potent
Hi
So I have been playing with an streaming cluster. I have the replication
working I believe.
But whilst attempting to do an import of my original DB, I filled up my
disk pg_xlog directory.
Strangley I have tried this before and not filled this up.
so
1) why did it fill up this time and not p
wrote:
> On 14 August 2017 08:39:54 GMT+02:00, Alex Samad
> wrote:
> >Hi
> >
> >I have setup a streaming replicating cluster, with a hot standby.
> >
> >Now I would like to change the RW to hot standby and change the hot
> >standby
> >to be the R
Hi
I have setup a streaming replicating cluster, with a hot standby.
Now I would like to change the RW to hot standby and change the hot standby
to be the RW server.
Is it just a matter of updating recover.conf file ?
Alex
On 3 August 2017 at 02:11, Scott Marlowe wrote:
> On Tue, Aug 1, 2017 at 4:27 PM, Alex Samad wrote:
> > Hi
> >
> > So just to go over what i have
> >
> >
> > server A (this is the original pgsql server 9.2)
> >
> > Server X and Server Y ... PGS
ks to server X, could I load
this up in PGSQL and do a table to table copy - i presume this would be
faster ... is this possible ? how do I get around the same DB name ?
What other solutions do I have ?
Alex
On 1 August 2017 at 23:24, Scott Marlowe wrote:
> On Mon, Jul 31, 2017 at 11:16
Hi
I double checked and there is data going over, thought I would correct that.
But it seems to be very slow. Having said that how do I / what tools do I
use to check through put
A
On 1 August 2017 at 08:56, Alex Samad wrote:
> Hi
>
> I'm using pg_dump 9.6 to do the dumps
Sun, Jul 30, 2017 at 7:13 PM, Alex Samad wrote:
> > How expensive is dynamic over static. I'm looking at storing yearly
> now, so
> > I figure if my if then clause has the latest year at the top it should be
> > very quick.
>
> Assuming you're not doing anythin
to a new single table so constraint shouldn't
be a problem.
Guess I have to just let it rung to completion
Thanks
On 1 August 2017 at 06:59, Scott Marlowe wrote:
> On Mon, Jul 31, 2017 at 2:31 AM, vinny wrote:
> > On 2017-07-31 11:02, Alex Samad wrote:
> >>
> >
ave M+ lines of rows.
Is there a way to tell the master to replicate earlier or is there a way to
get pg_dump to bundle into say 100K rows at a time ?
Thanks
Alex
Thanks
On 31 July 2017 at 18:11, Chris Travers wrote:
>
>
> On Mon, Jul 31, 2017 at 10:08 AM, Michael Paquier <
> michael.paqu...@gmail.com> wrote:
>
>> On Mon, Jul 31, 2017 at 7:28 AM, Andreas Kretschmer
>> wrote:
>> > The standby is read only, vacuum runs on the master and replicated to
>> th
Hi
setup a cluster, with streaming replication and hot stand by
the idea is to use the stand by to do queries whilst the primary is doing
inserts.
But I noticed the stats on the stand by server don't update, nor can I run
vacuum against it as its in recovery mode.
So how do update the stats and
How expensive is dynamic over static. I'm looking at storing yearly now,
so I figure if my if then clause has the latest year at the top it should
be very quick.
On 31 July 2017 at 11:07, Justin Pryzby wrote:
> On Mon, Jul 31, 2017 at 10:25:54AM +1000, Alex Samad wrote:
> > I
my insert trigger becomes a lot smaller and easier if I
leave it at yearly.
Also thinking if P10 was the current recommended version right now I would
probably look at MM because it looks like it makes partitioning easier
Alex
On 31 July 2017 at 09:54, Justin Pryzby wrote:
> On Mon, Jul 31,
Hi
I was about to partition a large (?) approx 3T of data 2B rows into
partition tables but broken up into MM ...
Now I have been reading about limiting the number of partitions otherwise
it could slow down the parser.
My reasoning for limiting to MM was that most of the request would be
now for the insert, do I create / update this monthly have had a 2 or 3
level if then check before inserting
or do I create a programatic insert that works out the table name
On 27 July 2017 at 18:36, John R Pierce wrote:
> On 7/27/2017 12:43 AM, Alex Samad wrote:
>
>>
>> ... as l
ote:
> On 7/26/2017 10:08 PM, Alex Samad wrote:
>
>> I have a large table about 3B rows, that I would like to partition on a
>> column called _received which is of type timestamp
>>
>>
> a good goal is to have no more than about 100 partitions max, and ideally
&g
.
I was thinking if I could change the check to be something like
check ( _recieved >= MM 1 00:00 and _recieved <= MM 23:59:59.999 )
so I am not sure how to make up the above line based on a timestamp
Thanks
Alex
Hi Jeff,
On Mon, Jun 12, 2017, at 06:42 PM, Jeff Janes wrote:
> On Mon, Jun 12, 2017 at 5:25 AM, Alex Kliukin
> wrote:>> __
>>
>> On Fri, Jun 2, 2017, at 11:51 AM, Alexander Kukushkin wrote:
>>> Hello hackers,
>>> There is one strange and awful thing I
ound configuring both PostgreSQL streaming
replication and Kubernetes cluster, and have a number of databases to manage,
as it makes little sense to build an aircraft carrier to carry a single Cessna.
Kind regards,
--
Oleksii “Alex" Kliukin
Hi,
I can search an array with 1 = ANY('{1,3,4,7}'::int[])
I need to check for one or multiple items in the array.
e.g. '1,7,3' = ANY('{1,3,4,7}'::int[]
I do need to check if
a) all items exist in the array
b) at least one item exists in the array
Is there a an operator that allows me to do th
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 all,
I have suspicions that my message don't get to pgsql-general mailing list.
Please, someone, answer this message if this get the mailing list.
Best regards, Alex
fired?
Best regards, Alex
On 08/25/2016 11:36 AM, Alex Lai wrote:
> Dear All,
>
> I have my log_line_prefix set to
> log_line_prefix = '[%d]%p %x %c[%l] %t %i'
> in postgresql.conf
>
> psql -c 'show timezone'
> TimeZone
>
> US/Eastern
>
> tai
eatly
appreciated.
--
Best regards,
Alex Lai (:-)
OMP SIPS DBA ADNET Systems, Inc.
7515 Mission Drive, Suite A100
Lanham, MD 20706
301 352-4657 (phone)
301 352-0437 (fax)
m...@sesda3.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
Hi,
I need some help with extracting data from json.
I have the following jsonb field
modules
{
"accounts": {"status": true},
"admin":{"status": true},
"calendar": {"status": false},
"chat": {"status": true},
"contacts": {"status": true},
"dashboard":
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
violates said compliance.
If anyone works at a similar company and utilizes postgresql to store PHI,
please let me know.
Thank you,
Alex
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi, is there a way to retrieve the comment of rules and triggers. I worked
it out on functions, tables, views but am kind of stuck with rules and
triggers.
Any help is appreciated.
Thanks
Alex
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
3834363 <-- Archive
3199 | 594 | 1096070 | 23834363 <-- Archive
3303 | 594 | 1305467 | 23834363
3303 | 594 | 1305467 | 23834363
4117 | 594 | 4000987 | 23834363
Thanks a lot for any ideas.
Alex
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
ee in perf stats? Maybe you can explain your problem
more in details?
Hi Alex ) I am hoping to find out which function calls are taking the
longest because to the code is taking too long to only parse a small
XML file and do a few quick database queries. The last version of
this software was able
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
Hi,
i am running and RDS instance on AWS but monitoring logs is a bit
cumbersome.
Is there a way to do the through pgadmin3 ? Like tailing the logfile?
Does anyone know when 9.5 will be available on aws?
Thanks
Alex
/extension/hstore_plperl.control
/usr/pgsql-9.5/share/extension/hstore_plperlu--1.0.sql
/usr/pgsql-9.5/share/extension/hstore_plperlu.control
/usr/pgsql-9.5/share/extension/hstore_plperl--1.0.sql
Thanks for any advice
Alex
ABLES IN SCHEMA public TO read_only ;
But i end up with permission denied errors.
Anyone having a suggestion how to get this to work? Did I mess up
permissions in public schema?
Any help and suggestion is greatly appreciated.
Alex
My postgresql 9.4 is installed in centos 6.7,and I have followed this:
http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/
1,cd /var/libpgsql/9.4/data
2,cp postgresql.conf.sample postgresql.conf
3,sudo vi postgresql.conf and add two lines,and save it:
> *listen_addresses =
1 - 100 of 667 matches
Mail list logo
