[ADMIN] Try to recover data

2008-10-03 Thread antonis
Hi, We had sata raid controller failure causing one dead harddrive and one that we managed to get all the data from in some experts lab. We were running postgres 8.2 using the debian (codename lenny) package 8.2 Since the data is much more important to us then its integrity we decided not to use

Re: [ADMIN] vacuum full problem

2003-11-07 Thread Antonis Antoniou
table pg_toast.pg_toast_16408;" Maybe an index is broken. Many Thanks Antonis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [ADMIN] vacuum full problem

2003-11-11 Thread Antonis Antoniou
Guys, does anyone has any idea? pginfo wrote: Hi, I try to reindex and reindex run ok, but the vacuum still not running. regards, ivan. Antonis Antoniou wrote: pginfo wrote: Hi, I am running pg 7.3.4 on linux red hat 9.0. If I try to execute vacuum full

Re: [ADMIN] How can i know the users that are loged in

2003-12-10 Thread Antonis Antoniou
Vasilis Ventirozos wrote: Hi all i want to ask something about user managment , How can i know the users that are loged thru an SQL command or how can i know who i am (my username) thru SQL again i can see that the users are loging so when i connect to a database a triger (maybe) raises an noti

Re: [ADMIN] pg dump restore

2004-08-24 Thread Antonis Antoniou
Edgars wrote: Hi all! such an easy question - i've dumped one of my postgresql databases in one file names 'first'. So now i want to put the structure of this old DB to another one named 'second'. How should i proceed with this? I think your question is not clear If the 'first' is a database nam

[ADMIN] moving from 7.4.13 to 8.0.14

2008-04-24 Thread Antonis Antoniou
.13 straight to 8.2? Many Thanks, Antonis -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin