(doesn't matter if they are "wrong") then the
better all round for Postgres.
This implies that ease of communication = quality of communication and I
am not buying it. Exhibit A, Twitter.
Tim
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing l
gander.net/
Work: http://www.redpill-linpro.com/
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
detail tables and use a regular index put on master
table link fields only? In another words, is it advisable *not* to have a
primary key on PostgreSQL table?
If answer changes according to OS underlying, I appreciate replies indicates
so.
Thanks & regards,
Ertan Küçükoğlu
--
Adrian
ty/irc/
or Stackoverflow:
http://stackoverflow.com/questions/tagged/postgresql
That would be fine too, but don't put it like "if you this is too much
work, you shouldn't be using postgresql".
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-genera
the 800 WALs number mean you have wal_keep_segments set to 800?
I dropped those slots but over time, the system kept on adding new WALs
without reusing them or deleting them.
Only after shutdown and restart the system deleted those WAL files.
Is that ok?
regards
Pupillo
--
Adrian Klaver
process doesn't waste time.
Regards
Pupillo
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/31/2017 08:21 AM, Thorsten Glaser wrote:
On Fri, 31 Mar 2017, Adrian Klaver wrote:
① that using a CHECK constraint to check data from another table
is wrong (but not why), and
Because that is a documented limitation:
https://www.postgresql.org/docs/9.6/static/sql-createtable.html
RIMARY KEY (parent, child)
);
This, however, gives me:
ERROR: referenced relation "vw_things_parents" is not a table
So, I might be doing it wrong (or not?), but how do I solve
this the best way?
Thanks in advance,
//mirabilos
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via p
On 03/30/2017 08:21 AM, Shaun Cutts wrote:
On Mar 30, 2017, at 10:02 AM, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
On 03/29/2017 06:19 PM, Shaun Cutts wrote:
When being asked to convert a day of the week, the to_date() function
returns
is a separate project from the Postgres server so I would
suggest adding that information to the existing issue in their issue
tracker:
https://redmine.postgresql.org/issues/2069
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
cuted on the primary, any
new mount point needed for it must be created on the primary and all
standby servers before the command is executed"
Thanks.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
-Behavior-tp5952910p5953046.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/Tablespace-Default-Behavior-tp5952910p5952929.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
other Sunday in some other year?
It comes down to what you want "select to_date(‘Monday’, ‘Day’)" to
provide you and for what purpose?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your su
the video as there are sound/video issues
before that.
Thanks in advance,
Moreno
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/29/2017 11:48 AM, Steve Crawford wrote:
On Wed, Mar 29, 2017 at 9:05 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 03/29/2017 08:49 AM, Steve Crawford wrote:
When firewalls/VPNs stand between my psql client
gly remember to close and restart connections, write all queries
in an external editor and then submit them, etc. but I'm looking for
more user friendly options.
Use the internal editor(\e)?
Cheers,
Steve
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pg
2017 19:42, David G. Johnston כתב:
On Tue, Mar 28, 2017 at 7:09 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>>wrote:
On 03/28/2017 12:29 AM, Ron Ben wrote:
Here is a refer to the stackoverflow question:
Maybe postgres didnt recognized it.
Posted also in
http://stackoverflow.com/questions/43090328/how-to-return-correct-local-time-in-postgres
Andrus.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
quick look seem to be a combination of:
https://www.postgresql.org/docs/9.6/static/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
and
https://www.postgresql.org/docs/9.6/static/plpgsql-errors-and-messages.html
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing l
eta on recent Windows 64 OSs
BTW, nowhere in the current documentation is mentioned the requirement
of the VC++ runtime library installation.
Thanks in advance
Hans Buschmann
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
the suggestions
provided. If you really want this as a built in, regardless of when it
is done I would suggest either filing bug:
https://www.postgresql.org/account/login/?next=/account/submitbug/
or
post to the --hackers list:
https://www.postgresql.org/list/pgsql-hackers/
--
Adrian Klaver
lay
#autovacuum_vacuum_cost_limit = -1# default vacuum cost limit for
# autovacuum, -1 means use
# vacuum_cost_limit
Any possible root cause? Is there a known issue in 9.4.6?
Thank you for your time!
--
Adrian Klaver
adrian.kla...@aklaver.com
s to previous requests
of this nature I'd say its not exactly a highly in-demand capability.
David J.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
from the front:
aklaver@test=> select (length('Tomomasaaa')+ 1) - position('om'
in reverse('Tomomasaaa'));
?column?
--
4
On Mon, Mar 27, 2017 at 11:43 AM, Adrian Klaver
<adrian.kla...@aklaver.com> wrote:
On 03/27/2017 08:05 AM, Ron Ben wr
end
and it will find the string according to this parameter.
This is pretty easy to implement and should be a part of the PostgreSQL
tools.
similar fuctionality exists in trim function where user can specify
leading or taling parameter
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gene
ations, but I didn't see anything highly relevant.
Thanks!
François
PS: Cross-posted to http://dba.stackexchange.com/q/168023/3935
[1]: https://duckduckgo.com/?q=postgresql+anonymize+data+dump+before+download
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
execute 'insert into cfg_global_audit1 select $1' using cfg_by_col1;
return new;
end if;
end;
$$
language plpgsql security definer;
And the same thing
Can someone point me what am I doing wrong ?
Thks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
/continuous-archiving.html
https://www.postgresql.org/docs/9.6/static/warm-standby.html#STREAMING-REPLICATION
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
b Medicine
University of Washington Medical Center
1959 NE Pacific St, MS 357110
Seattle WA 98195
work: (206) 598-8544
email: tekb...@uw.edu
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
OPY words_reviews (uid, author, nice, review, updated) FROM
stdin FORMAT csv;
ERROR: syntax error at or near "FORMAT"
LINE 1: ...s (uid, author, nice, review, updated) FROM stdin FORMAT csv...
^
--
Adrian Klaver
adrian.kla...@a
Not sure if it helps but this works:
test=# select extract(epoch from '1 year'::interval) > extract(epoch
from '32618665 years'::interval);
?column?
--
f
regards, tom lane
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (p
On 03/19/2017 01:54 AM, Sylvain Marechal wrote:
2017-03-18 20:40 GMT+01:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 03/18/2017 12:05 PM, Sylvain Marechal wrote:
Why not CASCADE?:
test=# ALTER TABLE test1 DROP CONSTRAINT
ry unique
constraint on table test1
The following solution works but causes me deadlocks problems with BDR:
Is the below wrapped in a transaction?
<<<
ALTER TABLE test2 DROP CONSTRAINT test2_t1_fkey;
ALTER TABLE test1 DROP CONSTRAINT test1_t1_key;
ALTER TABLE test2 ADD CONSTRAINT test2_t1_fkey
sion
GNU Make 4.1
Built for i386-portbld-freebsd10.0
cc --version
FreeBSD clang version 3.3 (tags/RELEASE_33/final 183502) 20130610
Target: i386-unknown-freebsd10.0
Thread model: posix
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
On 03/17/2017 07:31 AM, Steve Clark wrote:
On 03/17/2017 10:14 AM, Adrian Klaver wrote:
On 03/17/2017 06:58 AM, Steve Clark wrote:
On 03/17/2017 09:49 AM, Adrian Klaver wrote:
On 03/17/2017 06:42 AM, Steve Clark wrote:
Hi List,
I am running postgresql 8.4.20 on CentOS 6. Things have been
On 03/17/2017 06:58 AM, Steve Clark wrote:
On 03/17/2017 09:49 AM, Adrian Klaver wrote:
On 03/17/2017 06:42 AM, Steve Clark wrote:
Hi List,
I am running postgresql 8.4.20 on CentOS 6. Things have been running fine for a
long time
then I rebooted. Postgres came up but when I tried to connect
ot /var/run. I wonder whether your
problem is that you're trying to connect to it with distro-supplied
psql+libpq that expects to find the Unix socket in /var/run."
Thanks,
Steve
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@pos
On 03/17/2017 12:27 AM, Sridevi B wrote:
Ccing list.
Please reply to list also, it puts more eyes on the problem.
Hi Adrian,
Sorry for delay. Please find my answers inline.
Thanks,
Sridevi
On Thu, Mar 16, 2017 at 2:28 AM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adri
ridevi
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/14/2017 01:25 PM, Alexander Farber wrote:
Hi Adrian -
On Tue, Mar 14, 2017 at 7:18 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 03/14/2017 09:00 AM, Alexander Farber wrote:
My initial idea has been not to use ON CON
or taking of any action in reliance upon, this information by persons
or entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
system and destroy any copies.
--
Adrian Klaver
adrian.kla...@a
am afraid the logic is escaping me. If the record does not exist how
can you UPDATE it?
DELETE the rest (as I can't update them without a conflict) but I
haven't figured it out yet...
Thank you anyway
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-ge
necting it is just a matter of
when. So if I am following correctly you do not actually need a
connection to the Postgres server that is always on you just need one to
be available when you run a query or set of queries.
Thank you!
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent
On 03/14/2017 08:38 AM, Alexander Farber wrote:
Yes, Adrian -
On Tue, Mar 14, 2017 at 3:57 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 03/14/2017 07:23 AM, Alexander Farber wrote:
in _uids array I have all user i
84cb1e961857cccff","social":2,"given":"Abcde2","female":0,"stamp":1450102880},{"sid":"abcde","auth":"3fe693a84cb1e961857cccff","social":3,"given":"Abcde3","female":0,"stamp":1450102990},{"sid":"abcde","auth":"4fe693a84cb1e961857cccff","social":4,"given":"Abcde4","female":0,"stamp":145010}]'::jsonb,
'0.0.0.0'::inet);
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ed is your experiences in this theme?
What areas are problematic when we increase the "max_connection" number?
https://wiki.postgresql.org/wiki/Number_Of_Database_Connections
Thanks for any info!
Best wishes
dd
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general
nice,
review,
updated
FROM words_reviews
WHERE author <> out_uid
AND author = ANY(_uids)
ON CONFLICT DO NOTHING;
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-gen
anymore -abruptly- Amiga
entries before informing yourself about Amiga portings availability when
encoutering this platform name by chance on Wikipedia or other sites.
With respect,
Raffaele irlanda
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general
ink/?LinkId=550986> para
Windows 10
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ery if possible
Best regards
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/13/2017 09:19 AM, Tom Lane wrote:
Adrian Klaver <adrian.kla...@aklaver.com> writes:
On 03/13/2017 08:52 AM, Tom Lane wrote:
If by "history" you're worried about the server-side statement log, this
is merest fantasy: the createuser program is not magic, it just cons
gres-2017-03-13 09:03:27.147 PDT-0LOG: statement: create user
dummy_user with login password '1234';
If by "history" you mean ~/.psql_history, you could turn that off (psql -n)
or to protect the password specifically, you could use psql's \password
command.
ying to avoid. The immediate solution would be to
open the postgres database in pg_hba.conf. A longer term solution would
be to file an issue and see if the code can be changed to allow
specifying a database to createuser.
--
Guillaume.
http://blog.guillaume.lelarge.info
http://www.da
t=# INSERT INTO varchar_test VALUES ('tests');
ERROR: value too long for type character varying(4)
It just sets the upper limit of what can be entered.
would using regexp cost more CPU or memory resources?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgs
778a72136edf52cea56f2ab088b9449df9a48;hb=HEAD
with your additions.
Seems you have not restarted Postgres since the last time you had a
valid pg_hba.conf file. The above is not one. Remove the @***@ strings
and you should be good.
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
l-announce
In particular the PostgreSQL Weekly News that comes out Sunday or Monday
from David Fetter.
John
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
On 03/10/2017 01:25 AM, mac pack wrote:
2017-03-10 5:11 GMT+00:00 Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 03/09/2017 09:09 PM, Adrian Klaver wrote:
On 03/09/2017 03:55 AM, mac pack wrote:
Hi.
My Postg
On 03/09/2017 09:09 PM, Adrian Klaver wrote:
On 03/09/2017 03:55 AM, mac pack wrote:
Hi.
My PostgreSQL server was affect by a Ransomware virus. I'm trying to
restore the database from a dump file made by pg_dump in custom format
(-F c option), but the dump file seems to be damaged
ing archive
The follow commands works fine:
pg_restore -s db.backup > out.sql
pg_restore -l db.backup
Do you think it's possible to recover the dump file, is there any method
or tool to recover dump files?
Thanks.
Mário
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-g
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
accept connections
LOG: autovacuum launcher started
That means Postgres WAS started, just that the postgres port was unable
to be opened.
So if you do a pg_ctl stop, change the port in postgresql.conf to 5433
(or 5434) and then attempt
to restart, is your problem resolved?
--
Ad
On 03/09/2017 08:14 AM, John Iliffe wrote:
On Thursday 09 March 2017 09:17:51 Adrian Klaver wrote:
On 03/08/2017 09:28 PM, Tom Lane wrote:
John Iliffe <john.ili...@iliffe.ca> writes:
Comparing my results with Adrian's example, I notice that we both have the
Unix domain socket 5432 r
0 128:::postgresql :::*
users:(("postmaster",pid=849,fd=4))
tcpLISTEN 0 128 ::1:5442 :::*
users:(("postmaster",pid=848,fd=3))
>
> regards, tom lane
>
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
in?
Also, I am connected to the server by ssh so at least that IPv4 function is
working. (the router here only handles IPv4).
I did add 5432 to the firewalld configuration and rebooted to pick it up.
So, I think the network configuration is OK. I set that up as the first task
after install
I have that one fairly tightly locked down since this is a web server.
lsof says that there is nothing assigned to postmaster at this time.
Given that you can connect I have to believe lsof would show something,
so what options are you using with lsof and what user are you running it as?
On 03/08/2017 01:28 PM, John Iliffe wrote:
On Wednesday 08 March 2017 11:18:59 Adrian Klaver wrote:
On 03/08/2017 07:37 AM, John Iliffe wrote:
On Wednesday 08 March 2017 00:01:32 Tom Lane wrote:
John Iliffe <john.ili...@iliffe.ca> writes:
Now, running as user postgres I try and
On 03/08/2017 10:25 AM, John Iliffe wrote:
On Wednesday 08 March 2017 11:37:27 Adrian Klaver wrote:
On 03/08/2017 07:37 AM, John Iliffe wrote:
On Wednesday 08 March 2017 00:01:32 Tom Lane wrote:
John Iliffe <john.ili...@iliffe.ca> writes:
Now, running as user postgres I try and
of libpq?
It would probably show up in the package manager as something along the
lines of postgresql-client.
Thanks again.
John
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
issued a lot more messages before
crashing :-( Still couldn't connect to port 5432 though.
Meant to ask before, can you show the command you are using to connect?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
om ... so how up-to-date
is this server?
Good guess but no prize! I am on Fedora 25, downloaded and installed last
Saturday (4 March) and then patched to the current levels with dnf before I
started to do the application software installation.
regards, tom lane
--
Adrian K
No other instances of Postgres on the system. Since it wasn't working I
deleted the original installation by deleting the install directory.
How about the data directory?
If not could you explain what you meant?
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general ma
chase things.
Thanks in advance.
John
=====
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
rg//
/https://agency-software.org/demo/client/
ken.tan...@agency-software.org <mailto:ken.tan...@agency-software.org>
(253) 245-3801
Subscribe to the mailing list
<mailto:agency-general-requ...@lists.sourceforge.net?body=subscribe> to
learn more about AGENCY or
follow the discussion
wrote:
Trying to compile pgsql 9.6.2 on Fedora 25
I get the following message:
configure:9345: error: readline library not found
Please install readline-devel.
(BTW, https://yum.PostgreSQL.org has 9.6.2 and Fedora 25 RPMs already)
Regards,
--
Adrian Klaver
adrian.kla...@aklaver.com
and
s.doi is distinct from A.doi
Regards.
Johann
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to you
t function and It works.
If I am following correctly could not the function be eliminated by using?:
insert into cargo.invoice ( orderid, ) RETURNING id;
Regards,
Gunce
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.or
On 03/05/2017 03:01 AM, Peter J. Holzer wrote:
On 2017-03-03 06:39:35 -0800, Adrian Klaver wrote:
On 03/03/2017 12:33 AM, Peter J. Holzer wrote:
This is with PostgreSQL 9.5.6 on Debian Linux.
I noticed that according to pg_stat_user_tables autoanalyze has never
run on a lot of tables. Here
On 03/03/2017 11:50 AM, Sven R. Kunze wrote:
On 03.03.2017 16:05, Adrian Klaver wrote:
https://www.postgresql.org/docs/9.6/static/functions-json.html
As to why it works on JSON arrays:
Table 9-43. Additional jsonb Operators
"
? text Does the string exist as a top-level key w
On 03/02/2017 01:09 PM, Sven R. Kunze wrote:
On 28.02.2017 17:33, Adrian Klaver wrote:
On 02/26/2017 03:26 AM, Sven R. Kunze wrote:
Hello everyone,
playing around with jsonb and coming from this SO question
http://stackoverflow.com/questions/19925641/check-if-a-postgres-json-array-contains
s without updating
pg_stat_user_tables?
hp
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
should this:
$bid = $row['bid'];
$letters = $row['letters'];
$values = $row['values']
not be?:
$bid = $row['out_bid'];
$letters = $row['out_letters'];
$values = $row['out_values']
--
Adrian Klaver
adrian.kla
NULL,NULL,NULL,NULL,NULL,NULL}}
How to handle this please?
I was hoping to fetch a PHP array and process it with "foreach" in my
PHP-script.
Thank you
Alex
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
s errors or they may not be, that should be for the user to
determine after examining them.
Thanks
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 03/01/2017 12:15 AM, Johann Spies wrote:
On 28 February 2017 at 17:06, Adrian Klaver <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>> wrote:
I have not worked through all this but at first glance I suspect:
select distinct b.* from b ...
is d
On 02/28/2017 02:20 PM, Sasa Vilic wrote:
On 2017-02-28 16:41, Adrian Klaver wrote:
Seems to mean the simpler thing to do would be to set standby to
archive_mode = on, in which case the standby would not contribute WAL's
until it was promoted which would seem to be what you want.
Yes
e attributes of a constraint that was previously
created. Currently only foreign key constraints may be altered.
"
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ended way of testing inclusion in json lists?
I have not worked through your examples, but I suspect the answer's lie
here:
https://www.postgresql.org/docs/9.6/static/datatype-json.html#JSON-CONTAINMENT
8.14.3. jsonb Containment and Existence
Related docs: https://www.postgresql.org/docs/9.5/static/datatype-json.html
Regards,
Sven
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
b activity. Instead, the error
appears in both scenarios: with high db activity and with very low db
activity.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
On 02/28/2017 07:30 AM, Sven R. Kunze wrote:
On 28.02.2017 15:40, Adrian Klaver wrote:
[explanation of why date casting and to_datetime don't work]
Why is to_date not immutable?
Not sure, but if I where to hazard a guess, from the source code in
formatting.c:
https://git.postgresql.org
On 02/27/2017 11:14 PM, Sasa Vilic wrote:
On 2017-02-28 06:14, Adrian Klaver wrote:
On 02/27/2017 05:52 PM, Sasa Vilic wrote:
Because standby is running in syncronous replication, whereby wal
archiver is asynchronous. Therefore there is a small window where slave
has received the data
distinct b.* from b ...
is distinct from ...
constitutes a double negative.
What happens if you eliminate the first distinct?
Regards
Johann.
--
Because experiencing your loyal love is better than life itself,
my lips will praise you. (Psalm 63:3)
--
Adrian Klaver
adrian.kla...@aklaver.com
On 02/28/2017 01:35 AM, Sven R. Kunze wrote:
On 27.02.2017 18:17, Adrian Klaver wrote:
Yes, but is not about timezone dependency, it is about the other
dependencies listed in the second and third points. Namely the
datestyle setting and magic strings e.g. 'now'
I am sorry, I still don't
for more info:
https://www.postgresql.org/docs/9.6/static/warm-standby-failover.html
Regards,
Sasa
Am 28.02.2017 02:48 schrieb "Adrian Klaver" <adrian.kla...@aklaver.com
<mailto:adrian.kla...@aklaver.com>>:
On 02/27/2017 05:29 PM, Sasa Vilic wrote:
Master
still have a wal pushed from slave. Therefore there is
no interruption in WAL stream.
Still failing to see how the standby can have more information then what
the master had sent to it at the time of the crash.
Regards,
Sasa
On 28 February 2017 at 01:57, Adrian Klaver <adrian.
and standby supposed to be identical? After all, standby is just
consuming WAL that it is receiving from master ...
Or do you have any better suggestion on how to achieve continuous
incremental backup?
Thanks in advance
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing
On 02/27/2017 09:08 AM, Sven R. Kunze wrote:
On 27.02.2017 16:37, Adrian Klaver wrote:
On 02/27/2017 07:03 AM, Sven R. Kunze wrote:
Why is this relevant for dates? I cannot see that dates are
timezone-influenced.
Per Tom's post, see points 2 & 3:
Maybe, I am on a completely wrong t
f they don't, the application will suffer
from bad performance.
Thanks in advance for your replies.
Regards,
Sven
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
301 - 400 of 4904 matches
Mail list logo