On Wed, Apr 29, 2009 at 9:59 AM, Joshua D. Drake wrote:
> At this point you may be better off just doing a backup and restore and
> then figure out why your maintenance routines are failing.
OP said he was running 8.1. I think autovacuum was turned on by
default on 8.1, so first step after dump
On Wed, Apr 29, 2009 at 10:24:51PM +0200, Michael Monnerie wrote:
> On Mittwoch 29 April 2009 Alvaro Herrera wrote:
> > Michael Monnerie wrote:
> > > ERROR: CLUSTER cannot be executed from a function or multi-command
> > > string
> > >
> > > I got this error from a script which tried:
> > > psql -
m...@bortal.de wrote:
> any idea what i am doing wrong here?:
>
> pgtwo:/usr/local/src/postgresql-8.2.13/contrib/tsearch2/gendict#
> ./config.sh -n de -s -p german_UTF_8 -v -C 'Snowball stemmer for German
Do you understand German?:
http://www.tauceti.net/roller/cetixx/entry/volltextsuche_mit_pos
On Wed, Apr 29, 2009 at 4:00 PM, Scott Marlowe wrote:
> On Wed, Apr 29, 2009 at 9:59 AM, Joshua D. Drake
> wrote:
>
>> At this point you may be better off just doing a backup and restore and
>> then figure out why your maintenance routines are failing.
>
> OP said he was running 8.1. I think au
On Wed, 2009-04-29 at 13:36 +0100, william pink wrote:
> Hi,
>
> Unfortuneatly the partition that has the Postgres DB has filled up
> beause of files in the Postgres directory. this partition is 85GB
>
> I tried using Table space to point it at a new partition so I did
>
> exampledb=# CREATE TAB
Hello List,
any idea what i am doing wrong here?:
pgtwo:/usr/local/src/postgresql-8.2.13/contrib/tsearch2/gendict#
./config.sh -n de -s -p german_UTF_8 -v -C 'Snowball stemmer for German
(UTF8)'
Dictname: 'de'
Snowball stemmer: yes
Has init method: yes
Function prefix: german_UTF_8
Source fil
On Mittwoch 29 April 2009 Alvaro Herrera wrote:
> Michael Monnerie wrote:
> > ERROR: CLUSTER cannot be executed from a function or multi-command
> > string
> >
> > I got this error from a script which tried:
> > psql -U postgres db1 -c 'cluster ; analyze'
> >
> > In the docs there's no word that i
Hi,
Unfortuneatly the partition that has the Postgres DB has filled up beause of
files in the Postgres directory. this partition is 85GB
I tried using Table space to point it at a new partition so I did
exampledb=# CREATE TABLESPACE fastspace LOCATION '/var/example/postgres';
which didn't work
