>Date: Sun, 17 Nov 2002 16:37:16 -0800 >From: "David M. Cook" <dave@davidcook.org> >To: psyche-list@redhat.com >Subject: Re: database front end gui >Reply-To: psyche-list@redhat.com > >On Sat, Nov 16, 2002 at 06:36:13PM -0800, anthony baldwin wrote: > >> Hvae any of you run pgAccess? >> Are there any other non-proprietary, gpl database gui front ends? >> I am having difficulty with pgAccess. I htink it may be an issue with my >> Postgres set up. I seem to be unable to create a non-root user, but >> cannot sign in as "su postgres '. >> I want to catalog my books and do a few other things. >> Ideas? > >Try su'ing to root before su'ing to postgres: > >su >su postgres >createuser <username> > >Dave Cook > > Tried that...no luck. Others have suggested that there is no password, as well. but the terminal asks forone and if I simply press enter without giving one, I get the "incorrect password" message. >Message: 2 >Date: Sun, 17 Nov 2002 16:57:04 -0800 >From: Jesse Keating <hosting@j2solutions.net> >To: psyche-list@redhat.com >Subject: Re: database front end gui >Organization: j2Solutions >Reply-To: psyche-list@redhat.com > >On Sun, 17 Nov 2002 16:37:16 -0800 >"David M. Cook" <dave@davidcook.org> wrote: > ># ># su ># su postgres ># createuser <username> > >You really should use (su -) also, instead of just (su) > >-- >Jesse Keating >For Web Services and Linux Consulting, Visit --> j2Solutions.net >Mondo DevTeam (www.mondorescue.org) > >Was I helpful? Let others know: > http://svcs.affero.net/rm.php?r=jkeating > > >Message: 11 >Date: Mon, 18 Nov 2002 09:25:33 +0800 (WST) >From: John <psyche@computerdatasafe.com.au> >To: psyche-list@redhat.com >Subject: Re: database front end gui >Reply-To: psyche-list@redhat.com > >On Sun, 17 Nov 2002, Jesse Keating wrote: > >> On Sun, 17 Nov 2002 16:37:16 -0800 >> "David M. Cook" <dave@davidcook.org> wrote: >> >> # >> # su >> # su postgres >> # createuser <username> >> >> You really should use (su -) also, instead of just (su) > > >I always never use the su command. This is so much more convenient a way >to root things: > >summer@numbat summer]$ root magpie w > 9:22am up 24 days, 3:04, 14 users, load average: 2.00, 2.00, 2.00 >USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT >root pts/0 numbat.computerd Wed10am 4days 0.25s 0.11s less >/usr/share/doc/ >root pts/1 numbat.computerd Wed10am 4days 0.26s 0.26s -bash >root pts/2 numbat.computerd Wed10am 3days 0.12s 0.12s -bash >summer pts/3 numbat.computerd Wed10am 4days 0.16s 0.16s -bash >summer pts/4 numbat.computerd Fri11am 2days 1.36s 1.07s ssh -t >-l root gw >summer pts/5 numbat.computerd Wed10am 3days 0.12s 0.12s -bash >root pts/6 numbat.computerd Wed11am 4days 0.30s 0.30s -bash >summer pts/7 numbat.computerd Wed11am 4days 0.21s 0.03s man >tftpd >root pts/8 numbat.computerd Wed 1pm 4days 0.21s 0.21s -bash >summer pts/9 numbat.computerd Fri11am 2days 0.15s 0.15s -bash >root pts/10 numbat.computerd Fri11am 2days 1.56s 1.56s -bash >root pts/11 numbat.computerd Fri 2pm 2days 1.24s 1.09s ssh >wombat >root pts/12 gw.demo.room Fri 4pm 2days 0.14s 0.14s -bash >root pts/13 numbat.computerd 9:22am 1.00s 0.10s 0.10s w >Connection to magpie closed. >[summer@numbat summer]$ root >Last login: Sun Nov 17 14:26:26 2002 from numbat.computerdatasafe.com.au >[root@numbat root]# logout >Connection to numbat closed. >[summer@numbat summer]$ root gw >Last login: Mon Nov 18 03:58:07 2002 from gw.computerdatasafe.com.au >[root@gw root]# logout >Connection to gw closed. >[summer@numbat summer]$ > >Here's how it's done: >function root() > { > RH=$1 > shift > [ -z "$RH" ] && RH=${HOSTNAME} > ssh -t -l root $RH $@ > return $? > } > > >I have a newer way of doing the same thing on my RHL 8.0 box at home. > ?! _____________________________________________________________ Select your own custom email address for FREE! Get you@yourchoice.com w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag -- Psyche-list mailing list Psyche-list@redhat.com https://listman.redhat.com/mailman/listinfo/psyche-list
