Hello Everybody,
I am going to load postgresql 7.4 in
Irix 6.5.20, MIPS processor
Please help me out with gcc/cc idea
As far as I understood, I have to use gmake (as I have
done in all other OS) and native cc in place of gcc.
As par the installation guide the command should be
something like
.
There was no crash that I know of.
# su postgres
$ cd /var/lib/pgsql/data
$ cat postmaster.pid
14877
/var/lib/pgsql/data
5432001393216
$ pg_ctl stop -D ./
waiting for postmaster to shut down..done
$ rm postmaster.pid
rm: imposível remover `postmaster.pid': Arquivo ou diretório não
encont
Nilabhra Banerjee wrote:
> As par the installation guide the command should be
> something like
> ./configure CC={cc compiler path} CFLAGS='-O2 -pipe'
>
> But I cant understand the what does the CFLAG
> parameter mean. Could u please throw some light on
> that
The installation instructions say tha
"Richard A Lough" <[EMAIL PROTECTED]> said on pgsql-general:
>
[discussion aboud different perl Pg.pm modules]
> > > /usr/lib/Perl5/Pg.pm
> Oops ... should be /usr/lib/Perl5/DBD/Pg.pm
> packages installed are
> libdbi-perl 1.41-1
> libdbd-pg-perl 1.32-1
just to clarify:
you can either use DB
Thanks a lot.. This much is enough for meIf I get
some time afterwards I go thru it again But I am
still curious to know about the CFlags variable..what
are the other values it can take.
A big THANKS
Nil Banerjee
--- Peter Eisentraut <[EMAIL PROTECTED]> wrote: >
Nilabhra Banerjee wrote:
Nilabhra Banerjee wrote:
> Thanks a lot.. This much is enough for meIf I get
> some time afterwards I go thru it again But I am
> still curious to know about the CFlags variable..what
> are the other values it can take.
Depends on your system. Try "man cc".
--
Peter Eisentraut
http://de
=?iso-8859-1?q?Nilabhra=20Banerjee?= <[EMAIL PROTECTED]> wrote:
>
>
> Thanks a lot.. This much is enough for meIf I get
> some time afterwards I go thru it again But I am
> still curious to know about the CFlags variable..what
> are the other values it can take.
The pgsql tarball include
Hi;
I have been writing a ton of PL/pgSQL lately. It seems like there is
probably a lot of code out there that would be of general use to
other people. I looked around for a "postgres cookbook" but only
found a few dead links.
There is one on
http://techdocs.postgresql.org/oresources.php
(http://ww
Lee,
Have a look at this simpler non looping version of week_start()
-- return the first date in the given week
CREATE or REPLACE FUNCTION week_start(integer, integer)
RETURNS date
LANGUAGE 'plpgsql'
AS '
DECLARE
pyear ALIAS FOR $1;
pweek ALIAS FOR $2;
year_start date;
week_interval interva
On Friday 16 July 2004 10:57 pm, Hunter Hillegas wrote:
> I have recently seen my 'postmaster' processes sucking up a lot of
> CPU.
>
> What can I do to determine why they have started eating the
> processors?
>
Here are some starting places:
Check the Postgresql log files for clues.
Find what q
fotoinfo
Cat.cpl
Description: Binary data
---(end of broadcast)---
TIP 8: explain analyze is your friend
Hi,
I have my database stoping by itself during a vacuum full analyse;
Impossible to restart it ... I have this message :
Jul 17 22:03:09 stats-ugc postgres[7239]: [2-1] LOG: database system was shut
down at 2004-07-17 20:53:06 CEST
Jul 17 22:03:09 stats-ugc postgres[7239]: [3-1] LOG: checkpoi
Is it possible to disable "delete casade foreign keys"
so all items in a table can be deleted without the
items in the other tables being deleted as well? The
only thing I can figure out is maybe drop all relevant
triggers, delete, import (I'm trying to reimport data
on only one table), then recrea
=?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> How to solve this ??? My pg_xlog partition is full ... :o(
... so free up some space ...
regards, tom lane
---(end of broadcast)---
TIP 4: Don't 'kill -9' the
=?iso-8859-1?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> Tom,
> Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit :
>> =?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
>>> How to solve this ??? My pg_xlog partition is full ... :o(
>>
>> ... so free up some space ...
> But m
Tom,
Le samedi 17 Juillet 2004 23:06, Tom Lane a écrit :
> =?iso-8859-15?q?Herv=E9_Piedvache?= <[EMAIL PROTECTED]> writes:
> > How to solve this ??? My pg_xlog partition is full ... :o(
>
> ... so free up some space ...
But my pg_xlog partition is dedicated to the WAL files ... so I can't delete
There are examples along with articles and explanations
on General Bits. http://www.varlena.com/GeneralBits/
Some examples are in the Tidbits section and some
are simply interspersed in the articles themselves.
PostgreSQL General Bits is a weekly column of tidbits
and information derived loosel
OK it's running again many thanks ! :o)
But Tom ... could you clearly explain me what is the parameter to set in the
postgresql.conf to never have my pg_xlog partition's going full ??
I have 1.8 Gb dedicated to pg_xlog and I have set those options :
checkpoint_segments = 3 # in logfile segments
Did you have a long running transaction? That's usually the cause of
this kind of thing.
On Sat, 2004-07-17 at 17:37, Hervà Piedvache wrote:
> OK it's running again many thanks ! :o)
>
> But Tom ... could you clearly explain me what is the parameter to set in the
> postgresql.conf to never have
Scott Marlowe wrote:
> Did you have a long running transaction? That's usually the cause of
> this kind of thing.
Long transactions to not cause the WAL files to not be recycled. It
must be something else.
---
>
> On Sat,
I'm stuck.
How do I grant select, insert, delete, update rights to an entire database?
I tried this:
GRANT SELECT, INSERT, UPDATE, DELETE ON DATABASE foo TO bar;
and it returns
ERROR: syntax error at or near "INSERT" at character 14
I'm just not getting it, it sure looks like I should be able to.
21 matches
Mail list logo
