t a few more.
> And you are ulimiting the postgres user to 256 processes. So the kernel
says out of process space for that user.
Its the default values. can any one hint me where to change this ?
>
> Regards
>
> Russell Smith
>
--------------
Canaan Surfing Ltd.
In
192
cpu time (seconds, -t) unlimited
max user processes(-u) 256
virtual memory(kbytes, -v) unlimited
im totaly bogus, any ideas ?
Thanks
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 97
nd ld.conf
cheers
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax: 972-4-6990098
http://www.canaan.net.il
--
- Original Message -
From: "Adam Smith" <[EMAIL PROTECTED]&
Title: Database Size Limiting
I wonder if this will work:
each DB should assigned a diffrent user with set of
premissions ( including insert ).
a script that can revoke the inseret privilage will
emarge from time to time to check the DB size.
--Canaan Surfing Ltd.
i found a workaround, but relativly slow.
The column is not unique and when the update is finished i fire up a trigger
that check for uniqueness.
lets wait for pg7.5 :)
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Fax
Hi All
Does 7.4 support defferable updates on unique column ?
example
unique INT colum named u_test has the following values: 1, 2, 3, 4, 5
can i do update table set u_test = u_test + 1;
cheers
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
- Original Message -
From: "Shridhar Daithankar" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: "Nick Burrett" <[EMAIL PROTECTED]>; "postgresql"
<[EMAIL PROTECTED]>
Sent: Monday, October 20, 2003 3:06 P
what about mirroring only ? raid 1 ?
I always thought that raid 1 is the fastest, am I true ?
I don't really need more then 3GB data and I have two 36GB HD. so I don't
need lvl 0 nor lvl 5 unless raid 1 is slower.
--
Canaan Surfing Ltd.
Internet Service Provide
ystem of tables into Postgres that will enable the most
simplest fastest query.
If the developers think that the speed increase is irrelevant then lets drop
the issue :)
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Hi All
I need to do dumps for backups from a redhat6.2 mechine.
I dont want to install the whole server for just one utility nor could I
find a proper rpm.
Any sugestions ?
the server 7.1.3 is on redhat 7.1
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes
Can I:
select *, sum_rows as ( select count(*) from table2; ) from table1;
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast
Im using PHP4.6
> What are you using to develop? If perl, DBD::Pg will escape/unescape bytea
> data after 0.98 version. (Unescaping is automatic, to escape, you need to
> do bind(.., SQL_BINARY)).
>
> -alex
>
> On Fri, 24 Aug 2001, Ben-Nes Michael wrote:
>
> > But
select for output.
Does any one here save his website images on DB and retrive them out on his
web page ?
> "Ben-Nes Michael" <[EMAIL PROTECTED]> writes:
> > On the theoretical issue, can I use TEXT field to store binary ?
>
> TEXT will not handle null (zero) bytes
It sure is :)
On the theoretical issue, can I use TEXT field to store binary ?
If so, what will be the case with addslashes ? will it work ?
- Original Message -
From: "Joe Conway" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>; <[EMAIL
ood that...
>
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast)---
TIP 5: Have you checked our extensive
? ()
(gdb)
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 20, 2001 6:59 PM
Subject: Re: [GENERAL] VACUUM ANALYZE
>
> Hmm, unfortunate (was h
The RPM support locale ?
If not I cant use them :(
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 30, 2001 7:12 AM
Subject: Re: [GENERAL]
Yes I did with locale + debug
- Original Message -
From: "Trond Eivind Glomsrød" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 6:36 PM
Subject: Re: [GENERAL] readline and rh7.1
oblem ?
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Hi All
im trying to do the next thing, is it possible ?
CREATE TABLE language (
language serial PRIMARY KEY,
shortcut char(2) NOT NULL, unique, -- like il,en,fr,sp
);
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unr
.
Program terminated with signal 11, Segmentation fault.
#0 0x4014d8e0 in ?? ()
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Ben-Nes Michael" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, July 18, 2001 9:17 PM
Subject: Re:
?
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to
Use the Serial type for address_id.
And you should read the Manuals ! :)
- Original Message -
From: "Markus Jais" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 12:20 AM
Subject: [GENERAL] autoincrement???
> hi
> I have the following problem:
>
> I create the
re then one data dir ?
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
Hi All
Any one know if Postgres have a support for the Hebrew charset.
like when sorting with 'order by'
--
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-6-6925757
Fax: 972-6-6925858
http://www.canaan.co.il
--
25 matches
Mail list logo
