,
Your program is Java? Anyways, if your local TZ is +3 (like mine at the moment)
it would be likely the case.
I appreciate your time and attention.
Best regards.
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
to upgrade often so shouldn't you take advantage of all of the
new features and improvements when "finally" (to use your own word) upgrading?
Igal Sapir
Lucee Core Developer
Lucee.org <http://lucee.org/>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
of
psql .
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the database can generate in the checkpoint_timeout interval. Initially I had it set
based on the **average** volume of wal generated in that interval, setting it to 3 times that average, but that was not enough, triggering the unexpected behavior.
Thanks,
Vlad
--
Achilleas Mantzios
IT DEV
On 09/10/2017 17:13, Michael Paquier wrote:
On Mon, Oct 9, 2017 at 11:09 PM, Achilleas Mantzios
wrote:
In all pg conferences I have been, ppl scream : do not use pg_dump for
backups :)
It depends on what you are trying to achieve, pg_dump can be fine for
small-ish databases. By relying on
op_backup();"
Should it use rsync or pg_dump instead?
Thanks
--
World Peace Through Nuclear Pacification
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
feature
releases?.
Not particularly. You can do that sort of thing already via PAM,
for example.
Or LDAP as in our case.
regards, tom lane
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general
ack to database.
"
FYI, I also asked this question on
https://stackoverflow.com/questions/46301578/postgres-jdbc-logical-replication-lsn-feedback.
Thanks a lot and kind regards,
Yason TR
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing li
On 05/09/2017 13:26, Michael Paquier wrote:
On Tue, Sep 5, 2017 at 6:45 PM, Achilleas Mantzios
wrote:
Am I doing something wrong here?
I didn't sat that :) but you are right, STORAGE settings for copied col defs !=
tables's storage parameters. The key here is that LIKE deals wi
| extended | |
Am I doing something wrong here?
Thanks in advance.
Regards,
Milen Blagojevic
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
gt;
And then have this event trigger just save the timestamp value of
now() in a custom table with the name and/or OID of the relation
involved.
--
Michael
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
On 31/08/2017 16:12, Achilleas Mantzios wrote:
On 31/08/2017 14:03, haman...@t-online.de wrote:
On 31/08/2017 09:56, haman...@t-online.de wrote:
Hi,
is there a way to add a table create (and perhaps schema modify) timestamp to
the system?
I do occasionally create semi-temporary tables (meant
; parameter.
b) a dump/restore will modify the dates
That would be a problem, but this is not a common use case. Anyways you can
always write an event trigger and store some message in a log file. This should
survive dump/restores .
best regards
Wolfgang Hamann
--
Achilleas Mantzios
IT D
? (so a
weekly cron
could remind me of tables that are already a few days old but have no
explanatory comment)
I am running PG 9.3
Best regards
Wolfgang Hamann
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresq
s
checkpoint ;
(the ; is not meant as a smiley or whatever )
depends also on the values of checkpoint_segments
(max_wal_size/min_wal_size in Postgres 9.5 and onwards).
--
Michael
thanks
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
re.
What do you guys suggest?
Thanks in advance
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
27fa990f1f3261e1d09a11853 before the errors stopped
appearing "by themselves".
Best regards,
Adam
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:
-Pawan
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ll be more frequent than updates (re-ordering)
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
eplication between two
servers (master-slave).
Regards,
No.
Andreas
So, can I just comment those commands and remove the main/archive directory?
You'll lose the capability of PITR. Also what do you mean main/archive
directory? I hope you don't mean data/pg_xlog .
--
Achilleas Man
-2017-07-18_012530.log
[postgres@localhost ~]$
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
with only 32GB RAM
but ultra fast SSD disks. No problems.
IIRC the "fit DB into RAM" was a trend many years back. The new recommendation for shared buffers is about 25% of RAM. Leaving the rest to be utilized mainly by the kernel cache, also by other
programs in the system.
--
Willy
ery
Can anyone help me here?
How can I access DB2 LUW or zOS database tables from postgres?
I used to work with MVS many years ago. Good luck with your project.
For better diagnosis open all logs in both machines (postgresql, odbc, MVS,
DB2) and have a detailed view on them.
--
Thanks &
On 22/06/2017 20:30, Andres Freund wrote:
On 2017-06-22 18:10:40 +0300, Achilleas Mantzios wrote:
Once again having pg_largeobject as a system-catalog prevents LOs
from working smoothly. Neither replication nor having LOs on a
different tablespace (by moving pg_largeobject) works.
I think
On 22/06/2017 17:46, Andreas Joseph Krogh wrote:
På torsdag 22. juni 2017 kl. 15:25:20, skrev Achilleas Mantzios
mailto:ach...@matrix.gatewaynet.com>>:
On 22/06/2017 13:38, Andreas Joseph Krogh wrote:
På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios
mail
On 22/06/2017 13:38, Andreas Joseph Krogh wrote:
På torsdag 22. juni 2017 kl. 11:43:02, skrev Achilleas Mantzios
mailto:ach...@matrix.gatewaynet.com>>:
On 22/06/2017 11:21, Andreas Joseph Krogh wrote:
Hi.
1. Why should one prefer built-in logical replication in pg-10 to
pgl
AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ZbabaZZZ
7 | ZZZbabaZZZ
8 | ZZZbabaZZZ
9 | ZZZbabaZZZ
10 | ZZZbabaZZZ
11 | ZZZbabaZZZ
12 | ZZZbabaZZZ
13 | ZZZbabaZZZ
(13 rows)
select foo.* FROM (select id,to_jsonb(lala) as jzon from lala) as foo where jzon @>
'{"id":5}';
Am I missing something?
Thanks in adva
only?*
Write an ON UPDATE trigger on table B, and inside the code check for pg_trigger_depth() . If this is == 1 (called by user UPDATE) then RAISE an exception. If it is >1 then it is called by the other
trigger,
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ble
=
New attempt - number 3
Creating the table if it does not exist
Inserting the rows
Executing 0
Executing 4
^C
PostgreSQL version : 9.3.4
Best wishes,
Harry
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
,
Harry
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
you should check your syslogs/messages for any errors related to storage
- is your RAM ECC? Did you run any memtest?
- is your CPU overheating ?
- have you experienced any crashes/freezes ?
Please let me know if you require further info.
Best wishes,
Harry
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
.org
Best wishes,
Harry
On 7 Jun 2017, at 15:22, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
On 07/06/2017 16:33, ADSJ (Adam Sjøgren) wrote:
Our database has started reporting errors like this:
2017-05-31 13:48:10 CEST ERROR: unexpected chunk number 0 (expected 1)
e upgrading to PostgreSQL 9.3.17 during the weekend, but I'd like to
hear
if anyone has seen something like this, or have some ideas of how to
investigate/what the cause might be.
Best regards,
Adam
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgs
erit myt;
insert into myt values(1);
insert into mytc values(2);
select * from myt;
id
1
2
create table a (id integerreferences myt(id));
insert into a values(2);
ERROR: insert or update on table "a" violates foreign key constraint
"a_id_fkey"
DETAIL: Key (id)=(
7;s the postmaster. So it might
not be so trivial.
Any thoughts?
Thomas
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
.org
GnuPG ID: 0x1A7BFEC5
gpg --keyserver pgp.mit.edu --recv-keys 1A7BFEC5
"Everyone thinks of changing the world, but no one thinks of changing himself.”
- Leo Tolstoy
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-g
e power cables while running benchmarks to
be sure.
I've used the other Intel enterprise class ssds with good results on
the power plug pull tests.
+ Intel not only markets this as "Data Center SSD", moreover this seems to be in the
respective high-end range within "Data Center S
ata B N
Database consultant
-- Forwarded message --
From: *Achilleas Mantzios* mailto:ach...@matrix.gatewaynet.com>>
Date: 2017-02-17 11:20 GMT-02:00
Subject: Re: [GENERAL] Streaming Replication Without Downtime
To: pgsql-general@postgresql.org <mailto:pgsql-general@
roid-Mobiltelefon mit K-9 Mail gesendet.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
close the transaction if an error occures during
implementing patches.
Thanks in advanced for the answear.
Best regards,
Malgorzata Pomykacz
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
===
Any idea why this is happening, and how can I find a solution?
Thanks!
Regards,
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 20/12/2016 12:27, Andreas Joseph Krogh wrote:
På tirsdag 20. desember 2016 kl. 11:02:27, skrev Achilleas Mantzios
mailto:ach...@matrix.gatewaynet.com>>:
On 20/12/2016 11:43, Andreas Joseph Krogh wrote:
[snip]
BEGIN;
ALTER TABLE person ADD CONSTRAINT person_pk PRIMA
not having to also list all other columns selected
from the person-table.
How do I proceed with this?
Thanks.
--
*Andreas Joseph Krogh*
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andr...@visena.com <mailto:andr...@visena.com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
tem_attrs(get_raw_page('pg_toast.pg_toast_25203', 0),
25206);
t_xmin | t_xmax | t_ctid | chunk_id | chunk_seq
++++
2076 | 0 | (0,1) | \x7b620000 | \x
2076 | 0 | (0,2) | \x7b62 | \x0100
(2 rows)
Yours,
Laurenz Albe
--
Achilleas Mantzios
IT DEV
ld help to modify your log line prefix (log_line_prefix) to include
client's address, PID, and application name.
--
john r pierce, recycling bits in santa cruz
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
rhead. Is there a
way I can make the old master follow the new master without having to
do full backup?
pg_rewind
Subhankar Chattopadhyay
Bangalore, India
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
stgreSQL 9.2.14
Thanks!
Patrick.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
o make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
William Ivanski
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
vation
for doing this, and the consequences for backups, should be discussed
in "the right place" -- in or near the section that talks about file
locations in the context of server configuration.
All I can tell you is I haven't found one single piece of free (or not so free)
e's doing.
--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 25/11/2016 13:11, Juliano wrote:
Hi everyone,
How can I *use pg_dump* to do a backup of *"system catalogs"* only?
pg_dump --schema=pg_catalog
Regards,
Juliano
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
Thanks
Moreno.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lding) -> schemas
different organizations -> DBs
thanks
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
lation. Absolutely nothing should be shared between
two tenants.
WHy would multiple dbs be any worse than multiple schemas in performance?
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To mak
and new clusters on the
same server on FreeBSD?
The current FreeBSD Ports collection ports only allow ONE version to be
installed at a time.
In our installation, pgsql is one of the very few packages that we prefer to
deal by hand.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers
ecided to migrate all systems to PostgreSQL.
My personal experience is that MySQL is excellent for data that is not sensitive (web site, e-mail settings, etc). Everything else goes to PostgreSQL (or Oracle, or MS SQL Server, or Sybase, or DB2
- in *my* order of preference).
+1
Regards,
Edson Richter
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
e time and disk space.
Our last 1TB upgrade from 9.0 -> 9.3 went like a charm in something like
seconds. (with the -k option)
However, be warned that the planing and testing took one full week.
Regards,
Hristo S.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 19/07/2016 12:41, Andrew Sullivan wrote:
On Tue, Jul 19, 2016 at 12:37:10PM +0300, Achilleas Mantzios wrote:
Better to run, even slowly, than not run at all, or require special porting
team for every mysql client out there.
I'm not sure I agree. If you teach every naïve user that,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.post
arting with
creating wiki page listing such that works? This will help users who
want to use PostgreSQL with WordPress, MediaWikim Drupal etc. (and
many plugins).
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
--
. User sessions have size of 16M.
Not 160M.
for local network thick client has reasonable advantages.
We just can't implement today all functions on thin client.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-genera
OR REPLACE FUNCTION perfb.func91
...
BEGIN
PERFORM perfc."func911"();
...
END;
CREATE OR REPLACE FUNCTION perfc.func911 (
)
RETURNS void AS
$body$
DECLARE
svSql BIGINT;
BEGIN
svSql:=0;
...
svSql:=svSql+10;
END;
$body$
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
D
schemata.
On Tue, May 31, 2016 at 10:18 AM, Achilleas Mantzios mailto:ach...@matrix.gatewaynet.com>> wrote:
On 31/05/2016 10:45, CN wrote:
I have a feeling that slight enhancement to commands "SET ROLE" or "SET
SESSION AUTHORIZATION" can obsole
d modern cloud-inspired paradigms out there, our traditional
architecture might not of much interest any more, still I would love to make
the above happen some time.
Best Regards,
CN
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgs
its in santa cruz
--
--
Best Regards
Sameer Kumar | DB Solution Architect
*ASHNIK PTE. LTD.*
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 17/05/2016 20:38, Guyren Howe wrote:
On May 17, 2016, at 2:22 , Achilleas Mantzios
wrote:
Sorry if I missed something but what's wrong with pgadmin3 ?
Apart from it's awful, clunky, bug-ridden and crash prone, nothing.
There is a solution for that : either find the bugs
etter spent.
Sorry if I missed something but what's wrong with pgadmin3 ?
Geoff
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mail
One of my past
programmers (a fine kid always looking to learn) now writes IOS and Android apps in another country. Another one who didn't do much well with SQL, but rock-star programmer otherwise, now writes
javascript in another company.
--
regards Szymon Lipiński
--
Achilleas
author of this e-mail is
strictly prohibited. If you have
received this email in error please delete it and notify the sender
immediately. .
---
--
Achilleas Mantzios
IT DEV Lead
IT
#x27; <<< $name )
fi
==
Thank you!
---
Cal Heldenbrand
Web Operations at FBS
Creators of flexmls <http://flexmls.com>® and Spark Platform
<http://sparkplatform.com>
c...@fbsdata.com <mailto:c...@fbsdata.com>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
your solution and keep
us posted, many ppl might benefit from this.
Regards,
Alexey
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
Hello David
On 29/03/2016 14:04, David Rowley wrote:
On 29 March 2016 at 20:01, Achilleas Mantzios
wrote:
We are using PostgreSQL 9.3. Shouldn't the optimizer use a single call to
get_machdef_sister_defids in get_machdef_sister_defids_maxrh ??
It shouldn't be up to the optimizer t
tmppars := get_machdef_sister_defids(vdefid);
select max(rh) into tmp from items where vslwhid=vvslid and
itoar(defid) ~ tmppars;
RETURN tmp;
END;
$function$
# select get_machdef_sister_defids_maxrh(479,319435);
get_machdef_sister_defids_maxrh
-
On 24/02/2016 09:20, John R Pierce wrote:
On 2/23/2016 10:57 PM, Achilleas Mantzios wrote:
Of course it is. You can install PostgreSQL via packages, via ports or manually. I prefer the manual way and have been doing so for many years. FreeBSD peculiarities will start to bite (maybe,
maybe not
o run postgres on identical jails,
i.e. same user, same port? Was FreeBSD IPC ever jailified? Or did the recent
switch to mmap resolve this?
I'm running pg 9.4.6 in a FreeNAS (FreeBSD 9.3) jail without any hassle, and
very good performance, installed from ports via pkg install ...
--
rsions.
Would you please let em know if Postgres is supported on both FreeBSD x86
and x86_64.
Thanks in advance,
Preeti
--
thanks and regards,
Meera R Nair
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
s the reason CONSTRAINT TRIGGERS were introduced in PostgreSQL, I guess.
Just write an AFTER INSERT OR UPDATE TRIGGER ON config,
which checks for integrity.
cheers,
Chris
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
1:44 0020
-rw--- 1 postgres dba 262144 Feb 9 05:57 0021
-rw--- 1 postgres dba 262144 Feb 9 10:45 0022
-rw--- 1 postgres dba98304 Feb 10 13:35 0023
the members directory has 15723 files:
ls -l|wc -l
15723
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 10/02/2016 12:40, Karsten Hilbert wrote:
On Wed, Feb 10, 2016 at 10:34:53AM +0200, Achilleas Mantzios wrote:
PG on tankers:
About checksums in our office master DB that's a fine idea, too bad that
pg_upgrade doesn't cope with them
I am sure you have considered "failing o
stgreSQL *is* a reliable DB.
About checksums in our office master DB that's a fine idea, too bad that
pg_upgrade doesn't cope with them
(and upgrading without pg_upgrade is out of the question)
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ICU patch is ready? I
mean any risk without making a dump and import before the switch.
If this is okay for sure, what should I do later when the ICU is
available? Do I have to reindex everything with the ICU patched database?
Thank you.
M.
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
y who has deployed over 100 pgsql installations in the seven seas communicating over satellite by a hacked version of uucp and replicated via
a heavily hacked version of DBmirror.
So while I think that a CoC might help beginners stay, I don't think that this
is a major part, neither do I think
,
Xaver
Avast logo <https://www.avast.com/antivirus>
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
www.avast.com <https://www.avast.com/antivirus>
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
On 04/11/2015 17:53, Rob Sargent wrote:
On 11/04/2015 03:03 AM, Achilleas Mantzios wrote:
Sorry for being kind of late to the party (I was in 2015.PgConf.EU !!), and not
having read
most of the replies, what we have been successfully doing for this problem for
our app
is do it this way
ing command line
tools.
I hope you mean, its difficult to automate and version control
clickity-clicky work that goes into using GUI tools
automating shell scripts is trivial. putting said shell scripts into
version control is also trivial.
Yes, that is a typo on my part.
--
Achil
. and
known technical details about postgresql checkpoints.
i can not foud in the web answers for my question.
i would apreciate your answer. thanks a lot
--
Achilleas Mantzios
IT DEV Lead
IT DEPT
Dynacom Tankers Mgmt
ess you use ZFS or similarly
high-end FS.
Regarding file filesys based backups, apart from pg_basebackup which is a nice utility but built on top of the existing "Continuous Archiving" philosophy, the very feature was already implemented
since 8.*
--
Achilleas Mantzios
Head of IT DEV
IT
On 03/10/2014 05:54, Jim Nasby wrote:
On 10/2/14, 9:00 AM, Tom Lane wrote:
Achilleas Mantzios writes:
Was there ever any discussion.thought about being able to follow a non-strict
by name
column mapping between inherited tables and father tables?
No. You could use a view with UNION ALL
voice_no.
After all, generally speaking invoices have invoice_no's while general docs
have doc_no's , right?
So I think, the above scenario could be indeed be found a lot of times in
systems designed with no OO in mind.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgm
ostgresql.1045698.n5.nabble.com/Why-isn-t-Java-support-part-of-Postgresql-core-tp5819025.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@pos
case it should be
written :
"health" <> '' (i.e. comparison between the value of column "health" and the
literal value '')
'health' is one of the accepted values of the page table's
"Classification" column.
Many thanks,
-Davi
; desc
limit 100;
I'm not sure what "case WHEN 'health'<>'' THEN 'health' ELSE '%' end"
does. I follow everything just fine until I get to the 'health'<>''
condition. What does the single quotation mark mean? I can't seem to
find it in the documentation.
-David
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
t might be a while before we know those
results.
Any thoughts would be appreciated,
Try to re-write the query in a good form, and then perform EXPLAIN ANALYZE on
both systems
to see what's wrong.
David Noel
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
is not easy.
Fair enough.
You are welcome :)
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgs
On 11/04/2014 13:05, Alban Hertroys wrote:
On 11 Apr 2014, at 8:04, Achilleas Mantzios
wrote:
Basically it goes beyond what ppl would describe as OS holly wars.
If one chooses to go by FreeBSD, then he better be prepared to handle the
burden, both the part that is
imposed by the OS
right mind) would ever think of anything but BSD in a server role?
Jan
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ot;select version()"
version
-
PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
/proc/cpuinfo says: 8 CPUs, identified as "Intel(R) Xeon(R) CPU E5-2609 0 @
PostgreSQL 9.1.11 on x86_64-unknown-linux-gnu, compiled by gcc (Ubuntu/Linaro
4.6.3-1ubuntu5) 4.6.3, 64-bit
/proc/cpuinfo says: 8 CPUs, identified as "Intel(R) Xeon(R) CPU E5-2609 0 @
2.40GHz"
--
Achilleas Mantzios
Head of IT
about using ZoL in production
(albeit, not with PostgreSQL) and the current status of the project:
http://lanyrd.com/2013/linuxcon-north-america/scqmfb/
--
Achilleas Mantzios
Head of IT DEV
IT DEPT
Dynacom Tankers Mgmt
1 - 100 of 168 matches
Mail list logo
