[ADMIN] pg_upgrade cmdline issue

2002-02-11 Thread Markus Bertheau
Good day, why's that? (user is postgres, who owns /var/lib/pgsql/data/) bash-2.05$ bin/pg_upgrade -D /var/lib/pgsql/data/ -1 You must run pg_upgrade in either mode 1 or mode 2. Usage: pg_upgrade [-D datadir] -1 | -2 bash-2.05$ Markus Bertheau signature.asc Description: This is a digitall

Re: [ADMIN] restore whoes

2002-02-11 Thread Simone Tellini
On Sun, 10 Feb 2002 20:43:16 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: TL> I suppose you are working under Windows, or have copied the file into TL> Windows at some point. You need to find a way to avoid corrupting the TL> data file with Windows newline conversion. No, I was working under linu

Re: [ADMIN] restore whoes

2002-02-11 Thread Simone Tellini
On Sun, 10 Feb 2002 20:43:16 -0500 Tom Lane <[EMAIL PROTECTED]> wrote: TL> 160 O M U N A L E\r \ \r \n S E D U TL> 170 T A D E L 1 2 M A G G I O TL> TL> The newlines in the file have been translated to \r\n, which messes up oh, btw, the \r\n newlin

Re: [ADMIN] pg_upgrade cmdline issue

2002-02-11 Thread Simone Tellini
On 11 Feb 2002 09:35:46 +0100 Markus Bertheau <[EMAIL PROTECTED]> wrote: MB> bash-2.05$ bin/pg_upgrade -D /var/lib/pgsql/data/ -1 MB> You must run pg_upgrade in either mode 1 or mode 2. MB> Usage: pg_upgrade [-D datadir] -1 | -2 MB> bash-2.05$ I've got that too. Try export PGDATA=/var/lib/pgs

[ADMIN] Copying data

2002-02-11 Thread Madelon Brennan
What is the syntax for copying data from one database to another. I would like to take the data from my most current database and copy all of the data to my test environment. Thanks. -- Madelon L. Brennan Internet Development Coordinator Georgetown University [EMAIL PROTECTED] http://web.georgeto

Re: [ADMIN] Turn around !! Permissions on FUNCTIONS

2002-02-11 Thread Peter Eisentraut
Marco Tulio writes: > OK, the below is impossible yet... > > but anyone can give-me a TURN AROUND this problem ? > > Example: > > I have a tb_log thats registers all DELETES over another > table. I did it using a trigger and a function, because > a simple RULE can“t do ever I need. > > BUT, I don