* Dev Kumkar (devdas.kum...@gmail.com) wrote:
> > AFAIK, the binary name is postgres.exe, from what I've read they are
> > static linking openssl. the updated versions on the site linked in another
> > message are fixed per the note on that page.
> > http://www.enterprisedb.com/products-services-t
hi, Andy,
We are using streaming hot standby, no wal shipping.
I checked and base and pg_xlog. both are fine.
The extra space is used by /pg_multixact/members(about 5G) and
/pg_multixact/offsets(about 1.5G)
The doc said that pg_multixact contains multitransaction data used for
shared row lock
Hi,
On 2014-04-17 06:28:52 -0700, yhe wrote:
> We are using streaming hot standby, no wal shipping.
>
> I checked and base and pg_xlog. both are fine.
>
> The extra space is used by /pg_multixact/members(about 5G) and
> /pg_multixact/offsets(about 1.5G)
>
> The doc said that pg_multixact cont
On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
> So, who wants to work on this with me? I'm a fair arduino programmer,
> but know nothing about postgres.
I would look at the MySQL one as a first step to see how that was done.
You are basically going to need to duplicate libpq, which
Bruce Momjian writes:
> On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
>> So, who wants to work on this with me? I'm a fair arduino programmer,
>> but know nothing about postgres.
>
> I would look at the MySQL one as a first step to see how that was done.
> You are basically going t
On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote:
> Bruce Momjian writes:
> > On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
> >> So, who wants to work on this with me? I'm a fair arduino programmer,
> >> but know nothing about postgres.
> >
> > I would look at the MySQL
On 04/17/2014 07:44 AM, David Rysdam wrote:
Bruce Momjian writes:
On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
So, who wants to work on this with me? I'm a fair arduino programmer,
but know nothing about postgres.
I would look at the MySQL one as a first step to see how that
I've never had that happen before, and I've used Perl and DBI a lot.
Susan
On Wed, Apr 16, 2014 at 5:34 PM, Robert DiFalco wrote:
> Two common cases I can think of:
>
> 1. The PERL framework is only caching the insert and does not actually
> perform it until commit is issued.
> 2. You really ar
It is never committed, because the lookup for the insert fails.
Susan
On Wed, Apr 16, 2014 at 5:39 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
> Susan Cassidy-3 wrote
> > Nor can any regular SELECTs in the main program find it.
>
> Ever?
>
> If this is a same transaction visibilit
Bruce Momjian writes:
> On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote:
>> Maybe I'm being naive, but isn't libpq already being compiled for ARM by
>> Debian? As long as it fits, you should be good. If it doesn't, you'll
>> need to strip some stuff out.
>
> Oh, can you run Debian ARM
No, I am doing:
begin transaction
Loop:
Do some selects, including id on second iteration of the inserted id
Do the insert (function call), which also does a select on an id.
Save the newly inserted id for select on the next iteration. This id will
be selected by the insert function on the next it
No. One gets done automatically when the transaction fails, however. I
can see it in the log.
Susan
On Wed, Apr 16, 2014 at 6:26 PM, Andy Colson wrote:
> On 04/16/2014 07:06 PM, Susan Cassidy wrote:
>
>> Yes, it is the same connection. It is all the same transaction.
>>
>> Susan
>>
>>
>> On
There aren't multiple connections. It is a CGI program. One connection is
made when the program starts, and that is all.
I've looked at the log. It shows just what I expect, except that the
lookup does not work. 0 rows are returned from the select of the newly
inserted id.
Susan
On Wed, A
I suppose it's possible. I've never seen this behavior before, but I don't
think I've ever used this same scenario before. It is slightly unusual.
Susan
On Wed, Apr 16, 2014 at 11:55 PM, Alban Hertroys wrote:
> On 17 Apr 2014, at 2:49, David G Johnston
> wrote:
>
> > Robert DiFalco wrote
>
Except for the fact that I get the new id returned from the first insert,
which means that the insert probably did happen.
Susan
On Wed, Apr 16, 2014 at 11:55 PM, Alban Hertroys wrote:
> On 17 Apr 2014, at 2:49, David G Johnston
> wrote:
>
> > Robert DiFalco wrote
> >> Two common cases I can
On 04/17/14 10:49, Bruce Momjian wrote:
On Thu, Apr 17, 2014 at 10:44:36AM -0400, David Rysdam wrote:
Bruce Momjian writes:
> On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
>> So, who wants to work on this with me? I'm a fair arduino programmer,
>> but know nothing about postgres
hi, Andy,
Thanks. Right we are using 9.2.4 but plan to upgrade soon. I read 9.3.2
release notes and it is fixed specifically for this.
best,
Ying
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/hot-standby-data-folder-bigger-than-primary-tp5800402p5800545.html
Sent fr
Steve Spence writes:
> no, you can't run arm / debian on an arduino UNO. it's all c++
> compiled to machine code then uploaded.
This is how all executables work.
smime.p7s
Description: S/MIME cryptographic signature
So any chance of a self-contained test case so we're not all chasing our tails?
On Thu, Apr 17, 2014 at 9:06 AM, Susan Cassidy
wrote:
> Except for the fact that I get the new id returned from the first insert,
> which means that the insert probably did happen.
>
> Susan
>
>
> On Wed, Apr 16, 2014
Right. I don't know this code or DBI but many frameworks create a pool of ids
using sequence generators so that they can minimize round trips and know the id
of new records before the are written.
Sent from my iPhone
> On Apr 17, 2014, at 8:06 AM, Susan Cassidy
> wrote:
>
> Except for the f
On Mon, Jan 13, 2014 at 09:17:41AM -0500, Joseph Kregloh wrote:
>
>
>
> On Fri, Jan 10, 2014 at 11:53 AM, Adrian Klaver
> wrote:
>
> On 01/10/2014 08:40 AM, Joseph Kregloh wrote:
>
> Just as a followup to this. The process that I am using to do the
> upgrade is as follows:
Please note that everyone here but you is bottom-posting; please follow the
convention and list standard.
Susan Cassidy-3 wrote
> It is never committed, because the lookup for the insert fails.
So, alter the code so only the first insert happens then stop further
processing and go explore that s
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Bosco Rama wrote:
> Is it returning the right id? I seem to remember a recent thread
> about Perl DBI returning the wrong id's for certain operations.
Er...can you point me to that thread, please? I'd be very interested
in such a bug.
- --
I don't see how. It is a fairly complicated program, and the perl calls
are done through an API, which works fine in all other circumstances (I was
told I had to use an API, and not use the Perl calls directly).
I moved the code in the function inline into the code, and I still cannot
find the ne
On 4/17/2014 7:46 AM, Steve Spence wrote:
Not using arm or debian. Using a atmel 328p.
which is an AVR processor architecture. 16 bit, limited memory space.
you should be able to compile libpq as a static linkable library if you
have an AVR compiler, its pure C. I would leave out SSL supp
On 4/17/2014 9:44 AM, David Rysdam wrote:
Bruce Momjian writes:
On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
So, who wants to work on this with me? I'm a fair arduino programmer,
but know nothing about postgres.
I would look at the MySQL one as a first step to see how that w
On Thu, 17 Apr 2014 10:02:00 -0700
Susan Cassidy wrote:
> I moved the code in the function inline into the code, and I still cannot
> find the newly inserted id the next time through the loop.
I suppose you use DBD::Pg, whose current default isolation transaction level is
``Serializable''
D
I found the problem, and it is all my fault. I was calling the insert
function with the wrong combination of parameters, so naturally it didn't
find the item. It is working fine now, although I do think I needed to
mark the function as VOLATILE, which I think helped.
Thanks to all for the help.
> This will be fixed in the next 9.3 minor release by throwing ane error
> for non-existent tablespace directores.
>
>
Awesome! I have already upgraded my dev, stage, preprod, and production
environments to 9.3. However I do have some snapshots that I can test with.
> --
> Bruce Momjian
Perfect, thank you.
On Apr 16, 2014, at 9:56 PM, Michael Paquier wrote:
> On Thu, Apr 17, 2014 at 8:04 AM, Alan Nilsson wrote:
> Is it possible to allocate a small chunk of shared memory outside of any
> pools(i.e. manually alloced & de-alloced) that is visible to all processes?
> I would li
Dear list users,
For some tests, I installed a new cluster with different parameters
than the ones I had used a while ago to create the cluster I use for
my day-to-day activities (let's call it my main cluster). I used
initdb --no-locale -E UTF8 -D . Then I used pg_ctl -D
to start my new cluster.
On Thu, 17 Apr 2014 10:02:00 -0700
Susan Cassidy wrote:
> I moved the code in the function inline into the code, and I still cannot
> find the newly inserted id the next time through the loop.
I suppose you use DBD::Pg, whose current default isolation transaction level is
``Serializable''
D
My apologies to all, I posted with the wrong id; reposting
--
Regards, Vincent Veyron
http://libremen.com/
Legal case, contract and insurance claim management software
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chan
On 17.4.2014 16:51, Adrian Klaver wrote:
> On 04/17/2014 07:44 AM, David Rysdam wrote:
>> Bruce Momjian writes:
>>> On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
So, who wants to work on this with me? I'm a fair arduino programmer,
but know nothing about postgres.
>>>
>>>
On 17.4.2014 19:43, Steve Spence wrote:
> Oracle thought it was a good idea to put out a MySQL version, I
> figure there should be some effort to counter that here .
Really? I found no information about this on oracle.com or mysql.com,
except for a section in the discussion forum with ~20 post
On 04/17/2014 01:29 PM, Guillaume Drolet wrote:
Dear list users,
For some tests, I installed a new cluster with different parameters
than the ones I had used a while ago to create the cluster I use for
my day-to-day activities (let's call it my main cluster). I used
initdb --no-locale -E UTF8 -D
On 04/17/2014 03:04 PM, Tomas Vondra wrote:
On 17.4.2014 16:51, Adrian Klaver wrote:
On 04/17/2014 07:44 AM, David Rysdam wrote:
Bruce Momjian writes:
On Thu, Apr 17, 2014 at 09:39:55AM -0400, Steve Spence wrote:
So, who wants to work on this with me? I'm a fair arduino programmer,
but know
On 04/17/2014 01:29 PM, Guillaume Drolet wrote:
Dear list users,
For some tests, I installed a new cluster with different parameters
than the ones I had used a while ago to create the cluster I use for
my day-to-day activities (let's call it my main cluster). I used
initdb --no-locale -E UTF8 -D
On 04/17/2014 01:29 PM, Guillaume Drolet wrote:
Dear list users,
For some tests, I installed a new cluster with different parameters
than the ones I had used a while ago to create the cluster I use for
my day-to-day activities (let's call it my main cluster). I used
initdb --no-locale -E UTF8 -D
Hi Adrian,
I don't know the answer to #1. Was that a wildcard search?
As for #2, I should have been more clear, that's not a check that it does
every night. I just ran that check when it seemed to be down. It has been
a long time to since I've worked with it, so I didn't correctly recall that
I
On 04/17/2014 05:55 PM, Augori wrote:
Hi Adrian,
I don't know the answer to #1. Was that a wildcard search?
It was a grep of the processes running. You replied with this:
"Here's what the ps command gives:
root(at)server# ps ax | grep post
9165 pts/1S+ 0:00 grep post"
If postgres w
On 4/17/2014 9:09 PM, Steve Spence wrote:
You know what? Fine, it doesn't matter that much to me. I'm happy to
continue using MySQL. It works with the Arduino quite nicely. Postgres
doesn't work. That's Postgres loss not mine. I really thought the
postgres team would be interested in providing su
On 04/18/14 00:27, Steve Spence wrote:
On 4/18/2014 12:21 AM, John R Pierce wrote:
personal opinion:
I don't think a terminal device like a PC or an embedded system should
be talking directly to SQL at all. instead, they should be talking
to an application server which implements the "busine
On 18/04/14 16:27, Steve Spence wrote:
On 4/18/2014 12:21 AM, John R Pierce wrote:
personal opinion:
I don't think a terminal device like a PC or an embedded system
should be talking directly to SQL at all. instead, they should be
talking to an application server which implements the "busi
On 4/16/2014 2:40 PM, Robert DiFalco wrote:
Thanks Roxanne, I suppose when it comes down to it -- for the current
use cases and data size -- my only concern is the "calling" query that
will need to use max to determine if a user has already had a call
today. For a large user set, for each user
45 matches
Mail list logo
