My database has shutdown several times in the last couple days. I have no
idea why. I am running centos and I have not rebooted the server or made
any configuration changes. I am running postgres 8.2 and it has been
stable since I installed it about 5 months ago. The databases crashes and
so my
> <[EMAIL PROTECTED]> writes:
>
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes. I am running postgres 8.2 and it has been
>> stable since I installed it ab
> [EMAIL PROTECTED] writes:
>> My database has shutdown several times in the last couple days. I have
>> no
>> idea why. I am running centos and I have not rebooted the server or
>> made
>> any configuration changes.
>
> So in particular, you didn't disable memory overcommit?
>
>> LOG: server pr
Hello,
In config:
> # - Connection Settings -
>
> #listen_addresses = 'localhost' # what IP address(es) to listen on;
> # comma-separated list of addresses;
> # defaults to 'localhost', '*' = all
>
Hello,
I can not find configuration option to set init_children_process.
Where I can do it?
--
--
--
Publicidad y Servicios http://www.pas-world.com
Directorio http://www.precioventa.com
Tienda http://informatica.precioventa.com/es/
Autoridad certificadora http://ca.precioventa.co
I use to use postgres quite a bit but have been working on a project for a
couple years that does not use it. I have finally convinced them to make
the switch after our current database hsqldb couldn't keep up with the
task.
So, for this project I will need postgres working on a debian server
(2.
Thanks for the reply.
> [EMAIL PROTECTED] writes:
>> 1)Do I run these old versions on my linux servers and the new version
>> 8.1x
>> for development? If I do this will I have to constantly battle
>> compatibility issues when going from development to the production
>> servers? Will it be a big
I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I got installed on my windows box and my debian box. But is there a way
to install 8.2 on centos 4 using yum? I am fairly ignorant about yum but
am trying to figure this out.
---(end of broadcast)---
TIP 4: Have you searched our list archives
Excellent, thanks
> Hi,
>
> On Wed, 2006-12-06 at 23:32 -0800, [EMAIL PROTECTED] wrote:
>> I got installed on my windows box and my debian box. But is there a
>> way
>> to install 8.2 on centos 4 using yum?
>
> I am about to create a yum repo for PGDG RPM sets. Clodoaldo Pinto Neto
> sent me th
Are there any negatives to not specifying the length variable of a
character varying data type?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
I am migrating a system from hsqldb to postgresql. I have a bunch of
installs of this system live so moving the data is a headache. I was
using identities in hsqldb and now I am using sequences. I was able to
move all my data over however I am having an issue with the sequences. I
default them
Awesome. Thanks tom.
By the way I am still trying to find a yum install for 8.2 for
centos...anyone?
> [EMAIL PROTECTED] writes:
>> Is there a way to set it up so it knows to skip past existing ids?
>
> Usually you do something like
>
> select setval('seq_name', (select max(idcol) from tab
grant all privileges on database test to auser
As far as I can tell this does nothing. Intuitively this command suggests
that the auser would be able to access and modify the database test in
anyway. It would also suggest that as new tables for the database auser
would automatically have access
I am trying to loop through some data and then run insert some of the
resulting data into a new table. I can create the function but when I run
it i get the error:
ERROR: query "SELECT 'INSERT INTO payment (
id,amount,accepted_date, company_id , date ,
patient_responsible_party_id , patient_c
> On Wednesday 20 December 2006 7:36 pm, [EMAIL PROTECTED] wrote:
>> I am trying to loop through some data and then run insert some of the
>> resulting data into a new table. I can create the function but when I
>> run
>> it i get the error:
>>
>> ERROR: query "SELECT 'INSERT INTO payment (
>> id
> [EMAIL PROTECTED] wrote:
>> I am trying to loop through some data and then run insert some of the
>> resulting data into a new table. I can create the function but when I
>> run
>> it i get the error:
>>
>> ERROR: query "SELECT 'INSERT INTO payment (
>> id,amount,accepted_date, company_id , d
> [EMAIL PROTECTED] wrote:
>>> I believe you are wrong. the EXECUTE is being given 11 columns, it
>>> expects 1. I think you need to form your execute query like;
>>>
>>> EXECUTE 'INSERT INTO payment (
>>> id,amount,accepted_date, company_id , date ,
>>> patient_responsible_party_id patient_c
I've done quite a bit of reading on stored procedures recently and the
consensus seems to be that you shouldn't use them unless you really must.
I don't understand this argument. If you implement all of your logic in
the application then you need to make a network request to the database
serve
On 24/07/13 01:55, John Meyer wrote:
Taking an absolutist position either way is pretty blind. What is the
purpose of the procedure? Is it enforcing business rules? Are these
rules that must be enforced against already existing data or are they
more akin to validation of a credit card. How m
On 24/07/13 02:56, Andrew Sullivan wrote:
On Tue, Jul 23, 2013 at 06:55:56PM -0600, John Meyer wrote:
are accessing your database at one time? And most importantly, what
are you best at?
That is one of the most important questions, for sure, but there's a
close second that I'd suggest: what a
On 24/07/2013 14:58, Merlin Moncure wrote:
On Wed, Jul 24, 2013 at 8:31 AM, Some Developer
wrote:
On 24/07/13 14:21, Gauthier, Dave wrote:
I find stored procedures to be a God-send. The alternative, external
code, is the risky, difficult and often poorer performing approach to the
problems
On 24/07/13 20:33, Jeff Janes wrote:
On Tue, Jul 23, 2013 at 5:29 PM, Some Developer
wrote:
I've done quite a bit of reading on stored procedures recently and the
consensus seems to be that you shouldn't use them unless you really must.
I think that mostly speaks to the method yo
On 25/07/13 07:57, Luca Ferrari wrote:
On Thu, Jul 25, 2013 at 2:57 AM, Some Developer
wrote:
The added advantage of removing load from the app servers so they can
actually deal with serving the app is a bonus.
Uhm...I don't know what application you are developing, but I don'
On 25/07/13 08:14, Vincenzo Romano wrote:
2013/7/25 Luca Ferrari :
On Thu, Jul 25, 2013 at 2:57 AM, Some Developer
wrote:
The added advantage of removing load from the app servers so they can
actually deal with serving the app is a bonus.
Uhm...I don't know what application yo
improve the predictability of FOR
UPDATE's
interactions with LIMIT/OFFSET, and indeed it's improved the
predictability
of the behavior for you, just not in the direction you'd like :-(
regards, tom lane
--
Sincerely,
Yngve N. Pettersen
**
IN (SELECT random_id_sample())
FOR UPDATE
--
Sincerely,
Yngve N. Pettersen
****
Senior Developer Email: yn...@opera.com
Opera Software ASA http://www.opera.com/
Phone: +47 23 69 32 60
27 matches
Mail list logo
