Hello,
Thank you for your answer.
The person is charge of building PostGreSQL 8.1.0 has done a 32 bit
build and has used the "cc_r" compiler.
This person does not succeed to build PostGreSQL 8.1.0 with "gcc" and 64
bits. Unfortunatly, I don't have the errors or the logs of the 64 bits
build an
Hello,
The postmaster is launched by the user "pg_810" who is not the root user.
When I launch the "ulimit -a" command, I've got :
$ ulimit -a
time(seconds)unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes)unlimited
memory(kbytes) unlimited
Michael Fuhr writes:
On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
Any reason why a database would not get dumped by pg_dumpall?
Is there a way to check the successfull completion of pg_dumpall.
Loosing 3 databases is not an experience I want to repeat.
Perphaps it returns
On Tue, Dec 20, 2005 at 01:35:03PM +0100, DANTE ALEXANDRA wrote:
> You will find below the explain plan of one of the queries which has
> finished with "out of memory". This query contains aggregate and a
> sub-select with 6 joins :
1. Firstly, it could be the Hash node. Does the estimated numbe
Hi I am facing a proble when I am trying to store images, filse in postgreSQL.by using Bytea datatype field in table using setBinaryStream(). it show me exception inputstream is supported. please send me if anybody have solution of this problem. thanks kishore mukati ___
Hello, We´re running 8.0.4 in a Windows XP box and some of the applications are not working... Searching pg_log we´ve found the following messages: 2005-12-17 07:26:54 ERROR: could not read block 3 of relation 1663/17253/104561: Permission denied2005-12-17 09:26:11 ERROR: could not read
Hi,
Is there a way (from DBI) to deduce a sequence name from the table and
column it is attached to?
For instance:
Column| Type |Modifiers
-+-+--
Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> Is there a way (from DBI) to deduce a sequence name from the table and
> column it is attached to?
Since 8.0 you can use pg_get_serial_sequence(), see
http://www.postgresql.org/docs/8.0/static/functions-info.html
regards
DANTE ALEXANDRA wrote:
> The person is charge of building PostGreSQL 8.1.0 has done a 32 bit
> build and has used the "cc_r" compiler.
> This person does not succeed to build PostGreSQL 8.1.0 with "gcc" and 64
> bits. Unfortunatly, I don't have the errors or the logs of the 64 bits
> build and I ca
On Tue, Dec 20, 2005 at 10:31:46AM -0500, Tom Lane wrote:
> Louis-David Mitterrand <[EMAIL PROTECTED]> writes:
> > Is there a way (from DBI) to deduce a sequence name from the table and
> > column it is attached to?
>
> Since 8.0 you can use pg_get_serial_sequence(), see
> http://www.postgresql.or
On 12/19/05, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Michael Fuhr writes:
>
> > On Sun, Dec 18, 2005 at 11:29:13PM -0500, Francisco Reyes wrote:
> >> Any reason why a database would not get dumped by pg_dumpall?
> >> Always run pg_dumpall as the superuser.
> >
> > As the operating system super
kishore mukati wrote:
Hi
I am facing a proble when I am trying to store images, filse in
postgreSQL.by using Bytea datatype field in table
using setBinaryStream().
it show me exception
inputstream is supported.
please send me if anybody have solution of this problem.
thanks
kishore muka
Henrique Engelmann <[EMAIL PROTECTED]> writes:
> We´re running 8.0.4 in a Windows XP box and some of the applications are
> not working...
> Searching pg_log we´ve found the following messages:
> 2005-12-17 07:26:54 ERROR: could not read block 3 of relation
> 1663/17253/104561: Permis
Jaime Casanova writes:
- you still have the server where these databases exists?
No. I lost 3 databases.
- what version of pgsql, is this?
It was 8.0.4
I was upgrading to 8.1.
I checked the nightly jobs had been running, then ran a manual one and
proceeded to do the upgrade.
pg_dumpall
On Mon, Dec 19, 2005 at 08:37:26PM +0100, Martijn van Oosterhout wrote:
> I don't know which locales are affected. It just can't be that
> widespread because we're not getting similar reports for 99% of the
> locales out there.
Not getting reports doesn't mean the problem is rare.
Perhaps people m
On 12/20/05, Francisco Reyes <[EMAIL PROTECTED]> wrote:
> Jaime Casanova writes:
>
> > - you still have the server where these databases exists?
>
> No. I lost 3 databases.
>
> > - what version of pgsql, is this?
>
> It was 8.0.4
> I was upgrading to 8.1.
> I checked the nightly jobs had been runni
Martijn van Oosterhout writes:
> On Tue, Dec 20, 2005 at 01:35:03PM +0100, DANTE ALEXANDRA wrote:
>> You will find below the explain plan of one of the queries which has
>> finished with "out of memory". This query contains aggregate and a
>> sub-select with 6 joins :
> 1. Firstly, it could be th
Karsten Hilbert <[EMAIL PROTECTED]> writes:
> On Mon, Dec 19, 2005 at 08:37:26PM +0100, Martijn van Oosterhout wrote:
>> I don't know which locales are affected. It just can't be that
>> widespread because we're not getting similar reports for 99% of the
>> locales out there.
> Not getting reports
I'm certainly not an AIX expert, but I remember my 32-bit AIX programs
being limited to 256MB of heap by default. When I linked, I think I had
to ask for more maximum data page space using something like:
-bmaxdata:0x4000
(which asks for 1GB, I believe)
-Kevin Murphy
--
Hello,
The part table contains 6000 rows, so I think that the 96000 rows
estimated matches in part could match reality.
Currently, the lineitem table contains only one index :
TPCH=# \d lineitem
Table "public.lineitem"
Column | Type | Modifiers
-
Kevin Murphy <[EMAIL PROTECTED]> writes:
> I'm certainly not an AIX expert, but I remember my 32-bit AIX programs
> being limited to 256MB of heap by default.
Hmm ... if that's the case then it'd probably explain the problem.
Alexandra had work_mem set to 64MB, so the two hashes and sort would
th
Is it possible to store an index in a different table? Instead of
keeping the index in a separate column, I have a separate table for
storing all indexes. I am trying to set up something like this:
UPDATE indexTable SET index1=to_tsvector('default',coalesce(Table1.Data,''));
This is currently not
hi,
though I have worked for a while with SQLServer2000
but I am new to Postgres (and also new to using mailing lists), so please bear
with me if I am slower to pick these up.
I am trying to write a function in plpgsql that returns a
group of people.
The group is defined by a set of
On Tue, Dec 20, 2005 at 06:58:41PM +0100, Klein Bal?zs wrote:
> In practice however this doesn?t seem to work as the function never returns.
>
> Should this work in theory? Is this the recommended approach?
I can' think of any reason why it wouldn't work; have you tried adding
RAISE statements to
I am trying to run the following:
COPY departments (id, issue_id, title, description, feature_type) FROM
stdin;
23 4 Local BuzzThings to do, people to see, places to go. aspen
I get back:
COPY departments (id, issue_id, title, description, feature_type) FROM
stdin;
23 4 Local Buz
On Tue, 2005-12-20 at 13:30, Hunter's Lists wrote:
> I am trying to run the following:
>
> COPY departments (id, issue_id, title, description, feature_type) FROM
> stdin;
> 23 4 Local BuzzThings to do, people to see, places to go. aspen
>
> I get back:
>
> COPY departments (id, issue
Interesting.
How would I go about solving that?
I inserted an extra line between the two, no dice.
> From: Scott Marlowe <[EMAIL PROTECTED]>
> Date: Tue, 20 Dec 2005 13:53:37 -0600
> To: Hunter's Lists <[EMAIL PROTECTED]>
> Cc: PostgreSQL
> Subject: Re: [GENERAL] Syntax Error Inserting From STD
"Hunter's Lists" <[EMAIL PROTECTED]> writes:
> I get back:
> COPY departments (id, issue_id, title, description, feature_type) FROM
> stdin;
> 23 4 Local BuzzThings to do, people to see, places to go. aspen
> ERROR: syntax error at or near "23" at character 80
How are you feeding t
quick answer, try a different editor.
Are you editing in the same environment as the database is in, or are
you editing on windows and feeding the copy data in on another platform?
On Tue, 2005-12-20 at 14:40, Hunter's Lists wrote:
> Interesting.
>
> How would I go about solving that?
>
> I ins
Everything was on OS X.
Looks like it was a problem with spaces vs. tabs. Anyway, I went through and
fixed all the lines and everything went in.
We had a strange problem restoring a 8.0.4 dump to a 8.1.1 server and this
was the last of the data that had to be re-imported.
> From: Scott Marlowe <
Hi,
is there a newbie's FAQ / book / link for "howto optimize databases with
PostgreSQL"?
Background: Customer has the Windows* (sorry ) Postgres 8.1.0
standard installation "out of the box". A table has 2.5 mio records. No
indizes defined, primary key (sequence) does exist. In pgAdmin "sele
Dear Mr., My name is Chia. I'm a Malaysian student who still persuing my computer course. Now I'm working with a IT company for industry training. I got some questions about server. 1.) What I knew is when too many users access a database at the same time, it will slow down database
Hi Leonel at first thanks for help I try with that link you send to me but now I am getting a new error belowthis is exception in MyMailTracker.main()java.sql.SQLException: ERROR: column "attachment" is of type bytea but _expression_ is of type integer and one more thing my pos
kishore mukati wrote:
Hi Leonel
at first thanks for help
I try with that link you send to me
but now I am getting a new error
below
this is exception in MyMailTracker.main()java.sql.SQLException: ERROR:
column "attachment" is of type bytea but expression is of type integer
and one more t
am 20.12.2005, um 22:21:54 +0100 mailte Alexander Scholz folgendes:
> Hi,
>
> is there a newbie's FAQ / book / link for "howto optimize databases with
> PostgreSQL"?
07:12 < rtfm_please> For information about tuning
07:12 < rtfm_please> see http://www.powerpostgresql.com
07:12 < rtfm_please> or
35 matches
Mail list logo