On 24/07/17 15:01, PAWAN SHARMA wrote:
>
>
>
> On Mon, Jul 24, 2017 at 7:28 PM, Tim Clarke <mailto:tim.cla...@manifest.co.uk>> wrote:
>
>
>
> On 24/07/17 14:47, PAWAN SHARMA wrote:
> >
> > Hi Tim,
> >
> > Facing below
On 24/07/17 14:47, PAWAN SHARMA wrote:
>
> Hi Tim,
>
> Facing below issue
>
> [abc@test:/home/psharm89/nrpe-2.15]#
> Redirecting to /bin/systemctl restart xinetd.service
> Failed to restart xinetd.service: Unit xinetd.service failed to load:
> No such file or directory.
> [abc@test:/home/psharm8
We use nagios for all alerting, it'll do what you need.
Tim Clarke
On 24/07/17 12:38, Achilleas Mantzios wrote:
> pgbadger is a very nice reporting tool, overall, albeit not exactly at
> the system side, but more to the DBA side.
> For system level monitoring maybe take a look
On 05/04/17 18:22, Joshua D. Drake wrote:
> Stackoverflow gives back by providing an interface people want to use.
> It is free (as in beer) and is hugely popular.
>
> We need to be embracing these external communities because it is where
> our growth is. I run into people every single week that a
On 25/03/17 16:25, David G. Johnston wrote:
>
> One constraint is that the current email based flow cannot be
> disrupted. Adding on a fully integrated forum-like GUI does have some
> demand. I don't see it being met if the it needs to be custom
> written. Therefore, do you have any suggestions
ic for a blog post
>>
>> --
>> Kevin Grittner
>> EDB: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>>
> +1 - Confuses me every time
>
>
+1 me too
--
Tim Clarke
smime.p7s
Description: S/MIME Cryptographic Signature
I'd recommend Talend, they have an open source edition that we use. Very
powerful and reliable.
Tim Clarke
On 10/11/16 12:49, JingYuan Chen wrote:
>
> I think that ETL utilities will be the right choice. Try Pentaho's
> Data Integration tool. It is Java base.
>
>
Flask-Security==1.7.5
> Flask-SQLAlchemy==2.1
> Flask-WTF==0.13
>
> also:
>
> django-htmlmin==0.9.1
>
> Then run python setup.py.
Should those installs be into python 2 or python 3?
>
> Personally I would go this route:
>
> https://www.pgadmin.org/download/pip4.php
lask and python3-flask, probably
both installed as I flailed around trying to install pgAdmin4.
Tim Clarke
smime.p7s
Description: S/MIME Cryptographic Signature
On 30/09/16 18:35, Devrim Gündüz wrote:
> These are the -devel packages that I installed to build pgadmin4 RPMs:
> BuildRequires:mesa-libGL-devel
> BuildRequires:gcc-c++
> BuildRequires:qt5-qtbase-devel >= 5.1
> BuildRequires:qt5-qtwebkit-devel
> BuildRequires:
I.
-I/usr/include/qt4/QtCore -I/usr/include/qt4/QtNetwork
-I/usr/include/qt4/QtGui -I/usr/include/qt4/QtWebKit -I/usr/include/qt4
-I. -I. -o pgAdmin4.o pgAdmin4.cpp
In file included from TabWindow.h:16:0,
from BrowserWindow.h:16,
from pgAdmin4.cpp:29:
WebViewWi
The issue sounds more like your server than just Postgres - search the
net for "read only file system" for your OS.
Tim Clarke
On 27/06/16 14:28, Pau Marc Muñoz Torres wrote:
> Hello Everydody,
>
> My database is corrupted, each time i try to list all the tables in
> th
Wrap the source columns in your line:
txt:= txt1 || txt2 || txt3;
in coalesce() calls
Tim Clarke
On 12/05/16 09:47, Sridhar N Bamandlapally wrote:
> txt:= txt1 || txt2 || txt3;
smime.p7s
Description: S/MIME Cryptographic Signature
On 12/02/16 15:45, Adrian Klaver wrote:
> On 02/12/2016 07:37 AM, Sterpu Victor wrote:
>> Hello
>> Why is Postgres so slow on Windows compared to linux?
>> Can I do something to match the performance?
>> I have 2 servers:
>> - one is Windows 8, CPU XEON, 8 CORES, 32G of RAM - my test query runs
>>
idea
> their joke was mean.
>
> My other concern about CoCs is I fear someone is going to come and demand
> we change Master/Slave to Leader/Follower, because Master is a male term
> and Slave is insensitive to grand-children of slaves.
>
>
> Thanks,
> Regina
+1
--
Ti
Looks to me like argument types possibly? The article creates various
combinations of crosstab() function but you are passing in a query. Wrap
your query in quotes (and then escape those within it). Then you'll be
passing in a "text" type not an "unknown" as the error c
etely relaxed (or no) validation?
Tim Clarke
On 23/07/15 21:48, Adrian Klaver wrote:
> On 07/23/2015 12:04 PM, Jon Lapham wrote:
>> On 07/23/2015 03:02 PM, Adrian Klaver wrote:
>>> http://pgloader.io/
>>
>> Ok, thanks, I'll look into pgloader's data
a glass to the developers and maintainers).
Tim Clarke
On 08/07/15 20:24, Tim Clotworthy wrote:
> Hello,
>
> I have a customer that is about to undertake a migration of an Oracle 11g
> database to PostgreSQL 9.x (exact version to be determined). I am talking
> not only of the
on shifts and you're suddenly in UTC+1 or
> +3
>
> Thankfully, those things don't shift as fast as they sometimes do in the
> movies.
>
But every spring and autumn we do have daylight savings. How does that
work with time-zoney-woney timey-wimey calculations!
Tim Clarke
--
S
if you'd like me to break all that
apart for you.
Tim Clarke
On 07/05/15 02:15, Melvin Davidson wrote:
> Although not a PostgreSQL utility, in Linux, you can use screen or
> tmux to establish a connection and then disconnect.
>
> On Wed, May 6, 2015 at 6:48 PM, David G. Johnston
&
On 06/05/15 11:04, Gavin Flower wrote:
> See comments at bottom,
>
> On 06/05/15 20:47, Tim Clarke wrote:
>> We keep the DDL statements for any tables in our subversion code
>> repository just like any other programming code. Takes only a moment
>> then all history
On 05/05/15 18:41, Marc Fournier wrote:
>
> Fixed .. .let me know if there are any other issues …
>
>
<3
Tim Clarke
We keep the DDL statements for any tables in our subversion code
repository just like any other programming code. Takes only a moment
then all history or changes is available and comparable. svnserve on our
linux server, svn workbench on my ubuntu laptop, all open source :)
Tim Clarke
On 05/05
Two options that I know of:
1) Use Java and the Apache POI project
2) Write a file containing the data in some other format like HTML then
open that with Word.
Tim Clarke
On 30/03/15 09:20, avpro avpro wrote:
>
> Hi all,
>
> Have you ever experienced how to populate fields from a MS
less since it may give a long answer. Scan
down for packages that will provide your libwx* file(s) and then install
with 'yum install (package)'.
Good luck!
Tim Clarke
On 28/03/15 01:14, Yuri Budilov wrote:
> Hello everyone.
>
> I am new to PostgreSQL and Linux (coming across f
>> performance hit?
> Why don't you use the union-all approach? If it's fast, and does what
> you need ?
>
> depesz
>
Or create another index or column that's build at insertion time with
the sort that you want in it. At least then retrieval time will be fast
On 10/10/14 16:22, Tim Clarke wrote:
> On 10/10/14 16:14, Emi Lu wrote:
>> Hello,
>>
>> May I know from which version of psql JDBC driver, it provides
>> "org.postgresql.copy.CopyManager" please?
>>
>> postgresql-8.3-605.jdbc4.jar does not have thi
JDB3 and JDBC4 jar files on my 14.04 Ubuntu box.
It is *not* present in postgresql-8.3-604.jdbc4.jar on an older Fedora
box but it is there in postgresql-8.4-701.jdbc4.jar on the same machine.
HTH
--
Tim Clarke
IT Director
Manifest
9 Freebournes Court
Newland Street
Witham, Essex
CM8 2BL
England
ing to get all the way to the server and fail,
> blow out a transaction and carry that joyous news back to the user who
> now has to start over completely. Further no mear length constraint
> is going to fix p<=>[. Not say the db cannot have the constraint (no
> [ allowed?) but a good app checks input on the fly.
>
>
>
Indeed - both is the answer; back-end (trigger) checks for safety,
front-end application polite messages for clarity and ease of use.
--
Tim Clarke
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
s proven to be really stable. No JVM crashes
> after 2 years in production.
>
+1 for that; we are too.
--
Tim Clarke
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
hose other run components; the vacuum's
and other things that are only running with the backup and not during
the restore.
--
Tim Clarke
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ect everyone before renaming a
> database.
I'd change the pointer instead; in your client or front-end application
at your release point, change the reference to which database to work
with to the new one.
--
Tim Clarke
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To m
On 05/05/14 17:21, Alvaro Herrera wrote:
> Tim Clarke wrote:
>> Michael Tocci kindly announced these packages recently and they sound
>> promising but my search-fu is failing me - anyone got a link please?
> http://www.3comets.com/
>
> I posted a reply to his announce but
Michael Tocci kindly announced these packages recently and they sound
promising but my search-fu is failing me - anyone got a link please?
--
Tim Clarke
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org
34 matches
Mail list logo
