nually, of
course).
See /etc/apt/apt.conf.d/50unattended-upgrades (the default version of
that file includes documentation as comments).
Also see the unattended-upgrade(8) manpage, and the on/off switch in
/etc/apt/apt.conf.d/20auto-upgrades
--
Jan Claeys
--
Sent via pgsql-general mailing list
On Monday, October 2, 2017 2:32:34 AM EDT Frank Millman wrote:
> From: Frank Millman
> Sent: Friday, September 22, 2017 7:34 AM
> To: pgsql-general@postgresql.org
> Subject: Re: a JOIN to a VIEW seems slow
>
> On Fri, Sep 22, 2017 at 7:34 AM, Frank Millman wrote:
> > On Thu, Sep 21, 2017 at 3:54
On Sunday, June 25, 2017 11:02:41 PM EDT Alain Toussaint wrote:
> > Narrowing down the entire file to a small problem region and posting a
> > self-contained example,
>
> The url here contain the set of xml records from a publication I
> worked on many years ago:
>
> https://www.ncbi.nlm.nih.gov/
've had queries in the past which work in
postgresql which I couldn't run in sqlite, but this is the first time I
can recall where a query works in sqlite but not in postgresql).
--
Kind regards,
Jan Danielsson
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Tuesday, June 6, 2017 10:32:16 PM EDT Patrick B wrote:
> Hi guys,
>
> I've got tableA with 3 columns.
>
> id(seriaL) | type(character varying(256)) | string(character varying(256))
>
> I have the type/string value stored in another table, and from that i would
> like to get the id.
>
> Examp
On Wednesday, May 10, 2017 9:08:16 AM EDT Ron Ben wrote:
>
Ron,
You need to figure out how you can make your email client send something else
than base64 encoded HTML with right-aligned text. Your messages are so hard to
parse for me I just ignore them, and I assume there's other people t
On Fri, Apr 28, 2017 at 4:39 PM, Andrew Kerber
wrote:
> I am a fairly experienced Oracle DBA, and we are starting to move in to
> the PostgreSQL world. I would expect the standard monitoring items are
> required for mission critical postgres apps, Ie, disk space, wal log space,
> log monitoring,
On Thu, Apr 27, 2017 at 6:18 AM, basti wrote:
> Hallo, we have a Postgres database Server and around that there are 8
> clients get data from it.
>
> All servers are the the same datacenter i think (traceroute only 4-5 hops)
>
> Now we plan to move the server to an other hoster/datacenter.
>
> I h
On Thursday, April 20, 2017 3:38:42 AM EDT Tim Kane wrote:
> The pgss_query_texts.stat still wants to live in the default *pg_stat_tmp*
> directory, wether by design or not.. but that's a non-issue for me now.
A 30 second investigation of the source seems to indicate that that directory
is hardc
On Tuesday, April 11, 2017 5:43:29 AM EDT Osahon Oduware wrote:
> Hi,
>
> I am using Windows 7 OS and I have installed a GDAL with support for MrSID
> format. I want to build my PostGIS with the *--with-gdalconfig=FILE* to
> point to this new GDAL.
>
> How do I accomplish this in a Windows OS?
T
On Friday, February 10, 2017 6:46:08 PM EST David G. Johnston wrote:
> In short - this is the wrong list (pgsql-j...@postgresql.org is the
> appropriate one; or the official GitHub repo) and you need to provide some
> working self-contained examples showing exactly what you are doing.
>
> On Fri
>
> Hi guys,
>
> I've got the following Query:
>
> WITH
>
>query_p AS (
>
>SELECT CAST(6667176 AS
> BIGINT) AS client_id),
>
>
>
>
> clients AS (
>
>SELECT
>
On Thursday, December 29, 2016 5:10:08 AM EST rajmhn wrote:
> Gurus,
>
> Reading the data from file and loading it using pg_bulkload- C filter. As
> per documentation, C filter is much faster than SQL filter.
>
> I'm new to C. Gone through this documentation. Not clear, how to start.
> https://ww
On Wednesday, December 28, 2016 6:02:51 AM EST Mike Sofen wrote:
> the natural lashup of plpgsql to postgres (I liked Alban’s term,
> “impedance”), is a key aspect.
Not to deprive Alban of any of his credit, but the term "impedance mismatch"
is at least 25 year old; as far as I know it was coined
On Thursday, December 15, 2016 5:15:44 PM EST Thomas Kellerer wrote:
> Tom Lane schrieb am 15.12.2016 um 16:20:
> >> Still doesn't work:
> >> -bash-4.1$ pg_dump -d postgres -t "\"Statuses\""
> >> pg_dump: no matching tables were found
> >
> > Hmm. It might shed some light if you put "echo" in
On 2016-11-24 9:06 PM, Yogesh Sharma wrote:
Dear John,
Thanks for your support.
I mean to say, the REINDEX calls hourly and insert query executes every minute
to update.
So, it might be race condition that these queries can call at same time.
Why do you need to run REINDEX every hour? That s
On 2016-10-08 2:36 AM, Stephen Davies wrote:
On 07/10/16 19:24, Thomas Kellerer wrote:
Stephen Davies schrieb am 07.10.2016 um 10:46:
You can store the contents of a file in a bytea using plain JDBC no
lo_import() required
String sql = "insert into images (id, image_data) values (?,?)";
On 2016-09-26 1:15 AM, Gavin Flower wrote:
On 26/09/16 17:58, Patrick B wrote:
Hi guys,
I've got this domain:
CREATE DOMAIN public.a_city
AS character varying(80)
COLLATE pg_catalog."default";
And I need to increase the type from character varying(80) to
character varying(2
e as well as in stddev.
The whole DB
looks more like it is cruising, than fighting.
This example isn't a big database (40-80GB) or anything exotic. Just a
write heavy OLTP
load.
Regards, Jan
> Andreas
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-gene
On Sun, Jul 17, 2016 at 12:47 AM, Jan Wieck wrote:
>
> The only thing I can imagine would be that there is another slony cluster
> (or
> remnants of it) hanging around in the 9.4 installation, possibly in
> another database.
>
>
That does reproduce the problem. I ran the new
ibly in another
database.
Can you provide a list of all databases and all schemas in them from the
9.4 install?
Regards, Jan
>
>
> Not sure why it is still looking for slony1_funcs.2.2.2 even though the
> version is upgraded to 2.2.4 and it is running fine. i do see
>
ettings.
> raghu=#
>
> On Thu, Jun 16, 2016 at 8:51 PM, Jan de Visser wrote:
> > Please don't top-post.
> >
> > On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote:
> > > hi
> > > sir
> > > as per above discussion s
Please don't top-post.
On Thursday, June 16, 2016 8:30:53 PM EDT Durgamahesh Manne wrote:
> hi
> sir
> as per above discussion same error repeated even mentioned ip address of
> hostname
>
> ./runMTK.sh -sourcedbtype sqlserver -targetSchema public -schemaOnly
> -allTables dbo
>
>
> TARGET_DB_UR
Please don't top post.
On Thursday, June 16, 2016 3:42:53 AM EDT Yogesh Sharma wrote:
> Dear David sir/All,
>
> Thanks for your help.
> Just wanted to confirm few things.
>
> (9.3.5,9.2.9,9.1.14,9.0.18,8.4.22) Fix REASSIGN OWNED to not fail for text
> search objects (Álvaro Herrera)
> As per m
On Wednesday, June 15, 2016 9:07:10 PM EDT Alexander Farber wrote:
> I only understand a quarter of what you guys are writing,
> but to me the JDBC driver throwing SQLException
> "A result was returned when none was expected"
> when my stored function is declared as "void" with
>
> CREATE OR REPLA
On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote:
> On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote:
> > Point is that you're doing a SELECT. A SELECT returns a result, which can
> > be
> > empty. I would use executeQuery and ignore the result.
On Wednesday, June 15, 2016 10:43:13 AM EDT David G. Johnston wrote:
> On Wed, Jun 15, 2016 at 10:30 AM, Jan de Visser wrote:
> > Point is that you're doing a SELECT. A SELECT returns a result, which can
> > be
> > empty. I would use executeQuery and ignore the result.
On Wednesday, June 15, 2016 4:21:47 PM EDT Alexander Farber wrote:
> Hello Jan,
>
> On Wed, Jun 15, 2016 at 4:17 PM, Jan de Visser wrote:
> > On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote:
> > > Now I am trying to call the same function through JDBC
On Wednesday, June 15, 2016 3:56:07 PM EDT Alexander Farber wrote:
> Now I am trying to call the same function through JDBC driver 9.4.1208.jre7:
>
> private static final String SQL_SKIP_GAME =
> "SELECT words_skip_game(?, ?)";
>
> try (PreparedStatement st =
> mDatabase
On Monday, May 23, 2016 1:17:13 PM EDT Albe Laurenz wrote:
> David G. Johnston wrote:
>
> > On Mon, May 23, 2016 at 6:54 AM, aluka raju
> > wrote:
>
> >> As given in the FAQ's that postgresql cannot be embedded
> >> https://wiki.postgresql.org/wiki/FAQ#Can_PostgreSQL_be_embedded.3F .
> >>
> >>
On Friday, May 20, 2016 3:14:54 PM EDT Venkata Balaji N wrote:
> Hi,
>
> "make" command is generating the following error while compiling
> postgresql-9.5.3 on Solaris SPARC.
>
> I tried compiling 9.2 and 9.3, works fine. This is only happening on 9.5.
... snip ...
>
> Regards,
> Venkata B N
>
On Tuesday, May 17, 2016 9:41:51 AM EDT Bryan Nuse wrote:
> On 05/17/2016 08:25 AM, Victor Yegorov wrote:
> > I had a bit of fun with this SQL version and came up with this query:
> >
> > WITH src(s) AS (
> >
> > VALUES
> >
> > ('729472967293732174412176b12173b17111752171927491b1744171b1741121
On Wed, May 11, 2016 at 10:03 PM, Lucas Possamai
wrote:
>
>>>
>> Trying redoing the query with CTE as below:
>>
>> WITH ja_jobs as
>> (SELECT DISTINCT title
>> FROM ja_jobs
>> WHERE clientid = 31239 AND time_job > 1457826264
>> )
>> SELECT title
>> FROM ja_jobs
>> WHERE title ILI
On Tue, May 3, 2016 at 3:22 PM, Tom Lane wrote:
> Jan Keirse writes:
> > I have a table that used to contain all data.
> > because it grew too big I added a partition trigger a long time ago and
> > since than all new data was added to small partitions. By now all dat
tions easily takes over an hour during
which the table is locked.)
Is there some workaround for this?
Thanks,
Jan
--
DISCLAIMER
http://www.tvh.com/glob/en/email-disclaimer
"This message is delivered to all addressees subject to the conditions
set forth in the attached disclai
On Thursday, April 21, 2016 12:55:00 PM EDT Melvin Davidson wrote:
> WHY am I being vilified for making a simple request? How is it that
> developers proceed with other enhancements, yet so much negative attention
> is being given to my request because of unjustified fear that something bad
> will
On Friday, April 15, 2016 8:13:56 PM EDT Melvin Davidson wrote:
> *Thanks for the sympathetic feedback John. I understand people are
> reluctant to change. It was just my intent to enlighten others as to the
> true background behind it.*
> *So if it's not about to change, then I'll just have to cry
On Friday, March 18, 2016 1:18:01 PM EDT ando...@aule.net wrote:
> Hi,
>
> After upgrading to PostgreSQL 9.4.6, our test system gave error messages
> like:
>
> ERROR: invalid salt
>
> The cause of these errors is statements like:
>
> WHERE password = crypt('secret', 'secret')
>
> After
On March 8, 2016 03:00:14 PM da...@andl.org wrote:
> At the moment I have two pressing problems.
>
> One is the start-up phase: getting the Andl runtime stoked up, load its
> catalog, set up its execution environment (including its own type system),
> ready for business. That process in Postgres s
On March 8, 2016 11:35:00 AM da...@andl.org wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
>
> this stuff you're loading from the database once, that's just data about
> your language plugin's configuration, or is it user
On March 8, 2016 12:18:08 AM da...@andl.org wrote:
> From: pgsql-general-ow...@postgresql.org
> [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce
>
>
>
> Yes, I was aware of GD and SD. My question is about what facilities Postgres
> provides for implementing such a thing. Wh
to be proven wrong, but I suspect you'll find zero
correlation between implementation of CoC's and number of contributions
and/or contributors.
A wider question to the other participants in this discussion: Is it
generally an accepted view that the growth of the community (in some
sense
lly just as inconvenient, if you
have messages with the same subject. I've had gmail thread messages from
years apart because the subject was something like 'Hello'.
Jim
jan
On January 6, 2016 12:17:54 PM EST, "Stéphane Schildknecht"
wrote:
On 06/01/2016 1
On 2015-11-27 9:44 AM, Adrian Klaver wrote:
You realize how old 9.0 is, right? And you understand how nonsensical
your question is? How can you guarantee that code compiles properly on a
compiler which is released years after you write the code?
To me nonsensical would be trying to compile newe
.
with \dt or \list or other commands and select.
Hovever compiling it with gcc 3.4.6 and everythig works.
Is it intended (expected) behavior or a compiller bug (Being on
Gentoo, compiller bug scary me a lot).
thanx
jan
--
Sent via pgsql-general mailing list (pgsql-general
On September 14, 2015 07:22:58 AM Martín Marqués
wrote:
> I would recommend using psql's \password meta-
command instead of ALTER
> USER to change a password, as to avoid having the
password stamped in
> the logs.
You learn something new every day :-)
jan
On September 14, 2015 07:22:58 AM Martín Marqués
wrote:
> I would recommend using psql's \password meta-
command instead of ALTER
> USER to change a password, as to avoid having the
password stamped in
> the logs.
You learn something new every day :-)
jan
I
> determine the password used for postgres during the postgresql install?
> AND, why should it be different from the postgres user I created.
Try
jan@bison:~$ sudo -u postgres -s
postgres@bison:~$ psql
psql (9.4.4)
Type "help" for help.
postgres=# ALTER USER postgres PASSWOR
On Tue, Aug 18, 2015 at 1:00 PM, Jimit Amin wrote:
> Can I know normal, aggressive, best parameter settings for PostgreSQL.conf
> file for particular hardware.
>
> Like Linux x86_64 , 8 GB Ram
> , Linux x86_64 , 126 GB Ram
There's no generic answer because it depends on what you're doing with
the
On Tue, Aug 4, 2015 at 6:24 AM, William Dunn wrote:
> Hello Jan,
>
> I think your calculation is slightly off because per the docs when
> PostgreSQL comes within 1 million of the age at which an actual wraparound
> occurs it will go into the safety shutdown mode. Thus the calculat
On Thu, Jul 30, 2015 at 2:56 PM, Adrian Klaver
wrote:
> On 07/30/2015 02:55 AM, Jan Keirse wrote:
>>
>> Hello,
>>
>> we have some very write heavy databases and I have our monitoring
>> system watch the transaction age of my databases to be alerted befor
ient? Can
the transaction wrapparound freeze problem indeed occur earlier? And
if so, could someone suggest a better query to monitor?
Kind Regards,
Jan Keirse
--
DISCLAIMER
http://www.tvh.com/glob/en/email-disclaimer
"This message is delivered to all addressees subject to t
; 5000tps
>>
>> When I do it from a server that has a 13ms ping latency, it drops to 37tps.
>>
>> This is using the default pgbench script, is it to be expected?
>> If so, why?
>>
> Am 24.07.2015 um 20:06 schrieb Jan Lentfer :
>
> That seems to be a
That seems to be a large drop. On the other hand 13 ms is also like a very
large network latency. On LAN your usually in the sub ms area. So going from
e.g. 0.2 ms to 13ms is 65 fold decrease. What is the network toplogy like?
Jan
Von meinem iPad gesendet
> Am 24.07.2015 um 18:59 schr
On July 6, 2015 06:43:53 AM c.bu...@posteo.jp wrote:
> On 2015-07-05 15:13 Jan de Visser wrote:
> > You could set up a whole new server with a different $PGDATA on a
> > different port.
>
> I (and the user) don't want to setup anything - that is the point.
Well, you do
On July 5, 2015 08:58:17 PM c.bu...@posteo.jp wrote:
> On 2015-07-05 15:11 Charles Clavadetscher
>
> wrote:
> > I am not really an expert, but from your description I guess that you
> > assume an existing PostgreSQL installation on your customers' server.
>
> The application is a simple open sou
mp in a parallel way to do "logical" backups every night.
Regards,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On July 1, 2015 02:51:37 PM Urs G. Berner wrote:
> Am 01.07.15 um 14:08 schrieb Jan de Visser:
> > On July 1, 2015 07:39:59 AM Urs Berner wrote:
> .
> .
>
> > I would uninstall the stock (Ubuntu) version before installing the pgdg
> > version.
>
> There is
On July 1, 2015 07:39:59 AM Urs Berner wrote:
> I installed Ubuntu 14.04 LTS
> apg-get update ... apt-get upgrade ...
>
> and looked at
> www.postgresql.org/download/linux/ubuntu
> then added apt repository /etc/apt/sources.list.d/pgdg.list
>
> When I try
>
> apt-get install postgresql-9.4
>
>
On June 26, 2015 11:59:05 PM Robert Nikander wrote:
> Hi,
>
> (Maybe my subject line should be: `is not distinct from` and indexes.)
>
> In Postgres 9.4, I’ve got a table of ‘items’ that references a table
> ‘colors’. Not all items have colors, so I created a nullable column in
> items like:
>
ossibly re-read
http://www.postgresql.org/docs/9.4/static/continuous-archiving.html#BACKUP-PITR-RECOVERY
especially 24.3.3 and 24.3.4.
hth
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On June 3, 2015 02:04:28 PM Roxanne Reid-Bennett wrote:
> I think you should evaluate your unease with having to update the database
> on release (potentially many times) carefully for what it is and why you
> have it. [I'm not saying it is invalid - just know why you have it]
> Because no matter
temp_tablespace gets full, how postgresql will
react/manage the situation?
Queries running out of space in pgsql_tmp will just cancel (and
rollback).
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
On June 2, 2015 03:16:53 PM Zenaan Harkness wrote:
> On 6/2/15, Jan de Visser wrote:
> > On June 1, 2015 11:11:37 PM Arthur Silva wrote:
> >> In my opinion a twice a year schedule would be good.
> >> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions support
On June 1, 2015 11:11:37 PM Arthur Silva wrote:
> In my opinion a twice a year schedule would be good.
> The LTS would be every 2 or 4 releases. Keeping 2 LTS versions supported at
> all moments.
>
> Maybe this should be reposted to the hackers list?
Pretty sure this would be shot down pretty qui
unt_row_inst = 101)
>-> Index Only Scan using account_part1_pkey on account_part1
>(cost=0.42..8.44 rows=1 width=0)
>Index Cond: (account_row_inst = 101)
>(6 rows)
You can have a look at pg_partman. It makes setting up partitioning quite easy
and provides a tool to easily move existing data from parent to child tables.
Jan
.006 rows=0
>loops=1)
>Index Cond: (account_row_inst = 101)
>Heap Fetches: 0
>Planning time: 0.635 ms
>Execution time: 0.137 ms
>(18 rows)
>
>
>--
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:
>http://www.postgresql.org/mailpref/pgsql-general
Have you set up constraints on the partitions? The planner needs to know what
is in the child tables so it can avoid scanning them.
Jan
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
On May 25, 2015 04:17:32 PM Piotr Gasidło wrote:
> test_uuid=# drop extension "uuid-ossp";
> ERROR: cannot drop extension uuid-ossp because other
objects depend on it
> DETAIL: default for table test column id depends on function
> uuid_generate_v4() HINT: Use DROP ... CASCADE to drop the
depe
On May 23, 2015 01:48:11 PM David G. Johnston wrote:
> On Sat, May 23, 2015 at 1:34 PM, Ravi Krishna
>
> wrote:
> > Is it true that PG does not log undo information, only redo. If true,
> > then how does it bring a database back to consistent state during
> > crash recovery. Just curious.
>
> W
On May 21, 2015 11:56:52 AM Steve Crawford wrote:
> The article does also display a couple attitudes that I feel are especially
> rampant in the web-development community. The first is that web developers
> shouldn't become educated about the capabilities of a database but rather
> use the database
On May 21, 2015 06:04:37 PM Brown, Joseph E.
wrote:
> Unsubscribe pgsql-general
This doesn't work. See the footer of the posts to the
mailing list.
On May 4, 2015 02:32:14 PM Yves Dorfsman wrote:
> > As for performance concerns, in 99% of cases code maintainability is going
> > to be way more important than performance microoptimization. If you're
> > *that* concerned about performance than plpgsql probably isn't the right
> > answer anyway.
>
On March 28, 2015 06:18:49 PM Alex Magnum wrote:
> Hello,
> I am struggling with finding the right way to deal with arrays of composite
> types. Bellow is an example of the general setup where I defined an image
> type to describe the image properties. A user can have mulitple images
> stored.
The
On March 27, 2015 11:38:42 AM David G. Johnston wrote:
> On Fri, Mar 27, 2015 at 11:31 AM, Jan de Visser wrote:
> > On March 27, 2015 01:12:52 PM Eli Murray wrote:
> > > ERROR: syntax error at or near "json_build_object"
> > > LINE 1: insert into json(data)
On March 27, 2015 01:12:52 PM Eli Murray wrote:
> ERROR: syntax error at or near "json_build_object"
> LINE 1: insert into json(data) json_build_object(SELECT DISTINCT dep...
You may want to review the syntax of the INSERT command, i.e. this doesn't
have anything to do with JSON:
INSERT INTO fo
On March 25, 2015 09:31:24 PM David G. Johnston wrote:
> On Wed, Mar 25, 2015 at 8:58 PM, Mitu Verma wrote:
> > Correcting the subject
>
> And this is why it is considered good form to do "compose new message"
> instead of replying to an existing one. Injecting your new topic into an
> existin
On March 12, 2015 06:43:40 AM Gavin Flower wrote:
> Bill cannot comment, but it might be along the lines of assigning all
> intellectual property rights, or something of that ilk. In that case, it
> might give the company ownership of stuff he may have contributed (or
> intends to contribute) to
developer does the same “mistake” again.
Thanks
Jan
From: Jan Strube
Sent: Tuesday, February 10, 2015 12:03 PM
To: 'pgsql-general@postgresql.org'
Subject: Performance slowing down when doing same UPDATE many times
Hi,
we recently found a bug in one of our applications which
On March 1, 2015 09:45:24 AM inspector morse wrote:
> This is just for fun/research, I don't need a web framework because PHP is
> actually picking up the incoming requests and sending it to a pgsql stored
> function. The pgsql will concatenate all the html that is required for the
> page and send
On February 28, 2015 03:39:06 PM inspector morse wrote:
> Is it a good idea to write a simple application (consisting of just data
> entry interfaces) in pure pgsql?
>
> Basically, we would have each page has a stored function in postgresql that
> is called by php+apache (the http get/post values
0:00.00453
NOTICE: 00:00:00.004976
The problem only occurs inside a transaction and if the same dataset is
updated. I´m using PostgreSQL 9.1.15.
Jan
On December 21, 2014 04:08:43 PM Andomar wrote:
> It is not always easy to tell the query type (function, prepared or
> ad-hoc.) We use Python in mod_wsgi with psycopg2. The code shows ad-hoc
> SQL, but who knows what the many layers between Python and the database do.
psycopg2 sends the SQL you
send
data... try stracing the client to see what it does? (use "lsof -i :48848" or
whatever the port number of the remote is to find the pid).
--
Jan-Pieter Cornet
"Any sufficiently advanced incompetence is indistinguishable from malice."
- Grey's Law
signature.asc
Description: OpenPGP digital signature
g "status" fields and timestamps, so we could learn approximately how
many changes were missing from the backup that we restored.
Any suggestions on how to proceed? Thanks!
--
Jan-Pieter Cornet
"Any sufficiently advanced incompetence is indistinguishable from malice."
- Grey's Law
signature.asc
Description: OpenPGP digital signature
secure IP connections, directly
connect to a database, that is hosted on a publicly accessible VPS?
Maybe it is just me, but to me that design has DISASTER written in bold,
red, 120pt font all over it.
Good luck with that,
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via
message bus or queue.
The bus/queue receiver will then push the data into the database or
whatever downstream system.
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http
ractical purposes a small subset of functionality through
some gateway service would probably be a better approach.
Note that I am not an Arduino user/developer. I'm more familiar with the
Microchip PICs.
73 de WI3CK
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql
hould be to issue
STORE PATH commands with the new IP/hostname to the Slony replica(s).
Regards,
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mai
getting in the way then cancelling them is
still harmful, it's just not postgres' fault.
Slony (even the very old 1.2) does not cancel anything explicitly.
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
not one I agree with and I don't want a
Google search years from now to tie my name to that viewpoint.
Who (in their right mind) would ever think of anything but BSD in a
server role?
Jan
--
Jan Wieck
Senior Software Engineer
http://slony.info
--
Sent via pgsql-general mailing list
On 06/24/13 10:24, Rebecca Clarke wrote:
> I could be wrong, but shouldn't the owner of .pgpass be postgres?
The owner of ~/.pgpass is whoever owns ~ (the home directory of that user).
And ~/.pgpass must have permissions 0600 in order for libpq to actually
use it.
Jan
>
>
&g
txt
Does anyone have an idea what could be wrong here or how I can find out
where the memory is spend?
Thanks a lot,
Jan
P.S.: Here´s the log:
<2013-02-18 16:51:26 CET - idms_export> CONTEXT: PL/Perl function
"get_comment"
TopMemoryContext: 1272045600 total in 657683 block
rated from the
function which stores the COMMENT in cached_comments for the next select.
Is there perhaps a best practice to do a thing like that? Of course we
could declare the original function stable and call another volatile
function to store the data, as noted in the docs. But that would
is your function stable/immutable, and if so is it decorated as such.
merlin
No, it´s volatile.
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
quot;ISIN" IN (SELECT "ISIN" FROM dtng."Z_BASE" LIMIT 1)
We already found out that the problem is the Perl function "get_comment"
which is very expensive. In the first case the function is called at
most once, but in the second case it is called many times. I b
Hi,
you are right.
We were running 9.1.4 and after upgrading to 9.1.7 the error disappeared.
Thanks a lot,
JanStrube
I'm getting an out of memory error running the following query over 6
tables (the *BASE* tables have over 1 million rows each) on Postgresql
9.1. The machine has 4GB RAM:
It l
an on "W_BASE" wb (cost=0.00..93399.55 rows=1474955 width=207)
I tried reducing work_mem from 8MB to 64kB to force usage of temporary
files for the hash joins instead of working memory, as written in
chapter 18.4.1 of the documentation. But that didn´t help.
I know tha
n/postgres -D /var/lib/pgsql/data
That sould start your instance in foreground so you should see any
errors and messages during startup.
One more thing: is SELinux enabled?
Hope that helps :-)
Jan
On 19.12.2012 16:34, Jason Ma wrote:
> Hi,
>The ps output is after the server start, I
Hi all,
> I would very much appreciate a copy or a link to these slides!
here they are:
http://www.scribd.com/mobile/doc/61186429
Have fun!
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-ge
there).
Think about how you data is structured and how it is queried after it
was imported into the database to see where your bottlenecks are.
Cheers,
Jan
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 570 matches
Mail list logo
