'alter system archive log current' in Oracle.
Cheers.
Marc Cousin
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
I've been having this problem occurring a few times in the last few days : in
the postgresql log, I've seen these messages :
2007-03-28 13:53:34.845 CEST,18249 LOG: SSL SYSCALL error: Broken pipe
2007-03-28 13:53:34.846 CEST,18249 LOG: SSL SYSCALL error: Broken pipe
2007-03-28 13:53:34.84
It seems to be what occurred : the windows client crashed ...
Still, it's a bit of a problem to have a filesystem full in a matter of
minutes just because a client machine crashed while having an SSL connection
opened on the postgresql server...
On Thursday 29 March 2007 19:40:18 Peter Koczan wr
as well as possible.
Thanks a lot for feedback...
Marc Cousin
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
On Thursday 07 June 2007 18:40:37 Joshua D. Drake wrote:
> Abraham, Danny wrote:
> > Hi,
> >
> > I am migrating from Sybase to Postgres.
> >
> > trying to get a hold on the issue of future releases feature list.
> >
> > 1. Where can I find the feature list for 8.3 ? When is it expected?
>
> The ro
Hi,
I'm having this problem on Windows 2003-SP1, with Postgresql 8.2.
At a certain moment (after several hours of use, randomly), the postgresql
server stops responding. When checking in the log, I see this message
repeatedly :
Could not send data to client: Unknown winsock error 10055
The prob
Hi,
I cannot select any other role than public in the privileges tab in pgadmin
1.8.2. I see this for at least schemas and tables.
Is it a known bug, a normal behavior, an unknown bug ? :)
Cheers
Marc Cousin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes
Hi,
I'm having a strange problem : I created a view in a database, and I cannot
restore it after a pg_dump.
I'm creating this view :
CREATE VIEW vj_icsi_integration_winaudit_isiparc AS
SELECT DISTINCT objet.c_barre ,
resume.computer ,
anagement_systeme_memoire.devicenumber)::text) AS
devicenumber FROM
winaudit.winaudit_management_systeme_memoire GROUP BY
winaudit_management_systeme_memoire.computer) memoire ORDER BY CASE WHEN
(memoire.devicenumber = '{1,2}'::text[])
THEN 2 WHEN (memoire.devicenumber
ostgreSQL for a while now ...
Thanks in advance.
On Friday 04 April 2008 15:21:52 Marc Cousin wrote:
> I've forgotten to add this information :
>
> Version :
> infocentre_dte=# SELECT * from version();
>
h a syntax error at other times... It's the first
> > time I've seen it, and I've been using PostgreSQL for a while now ...
> >
> > Thanks in advance.
> >
> > On Friday 04 April 2008 15:21:52 Marc Cousin wrote:
&
I've installed it and it works. Thanks a lot.
On Saturday 12 April 2008 01:01:06 Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > I'm having a strange problem : I created a view in a database, and I
> > cannot restore it after a pg_dump. ...
> >
Hi,
I'm having a problem with plpgsql functions leaking memory.
I've reproduced the problem with this simple function here :
CREATE OR REPLACE FUNCTION ftest()
RETURNS boolean AS
$BODY$BEGIN
INSERT INTO test2 values (1);
RETURN true;
END;$BODY$
LANGUAGE 'plpgsql' VOLATILE;
test2 table is a
On Tuesday 24 June 2008 16:56:10 Tom Lane wrote:
> Marc Cousin <[EMAIL PROTECTED]> writes:
> > I'm having a problem with plpgsql functions leaking memory.
>
> Your example shows absolutely no memory leak here, in either 8.3.3
> or CVS HEAD.
>
> > I see the
Hi, I'm having a problem cancelling a query.
I've already had sometimes this kind of problem, but not this hard (and I
didn't find anything searching the archives, but still I remember seeing
discussions about this). Usually, it cancels in a few seconds to a minute.
I've run this query an hou
On Tuesday 05 May 2009 16:35:11 Tom Lane wrote:
> Marc Cousin writes:
> > [ can't cancel this query ]
> >
> > Index Scan using file_jpfid_idx on file (cost=0.00..7327212.07
> > rows=2128 width=104)
> >Index Cond: (pathid = 120)
> >
> >
great, thanks a lot...
On Tuesday 05 May 2009 17:11:35 Tom Lane wrote:
> Marc Cousin writes:
> > On Tuesday 05 May 2009 16:35:11 Tom Lane wrote:
> >> Hmm ... is it likely that index entries with pathid = 120 are *very* few
> >> and far between in jobid order
Hi,
I don't know if this is a known problem, or something I'm doing wrong,
but pg_restore -j tends to sometimes mix lines, or even completely
drop some. Here is an example (it's a -j12 run):
pg_restore: pg_restore: restoring data for table
"edw_iu_paglac_axe1_kpi_lac_month_bh"
restoring data fo
18 matches
Mail list logo
