On Sat, Jul 21, 2001 at 06:42:46AM +0000, p wrote: > > On Wed, Jul 11, 2001 at 09:04:01PM -0400, Brian Schramm wrote: > > [snip] > > > problem is that the postgresql database says that my username does not > > > exist in the pg_shadow file any more. I thought that this was a problem > > > that > > > the users did not transfer so I created another user with the create user > > > command. It still tells me that the pg_shadow file does not contain the > > > user. Any ideas? > > // > > On Fri, Jul 13, 2001 at 01:28:45AM -0500, will trillich wrote: > > > > can you get in via the postgres superuser? (su to root, then su > > to postgres). maybe try createuser from the postgres account. > > // > > thx, will. > > i was looking at this exact prob for about 2 hrs yesterday and > still couldn't find how to do it. (i even bought momjian's > "postgresql--intro and concepts" book and was still shootin' > blanks.) > > at least now i should be able to start creating db's and having > fun.
glad i could help... sorry i needed to... :/ my trouble at the moment is that 'psql' MANDATES that i supply a dbname, even if i'm going to 'psql -l' or 'psql -V', which i'll post in a separate thread. (i'm on pg 7.1 now, but still using potato.) > <aside>man's may be good for the broad picture, but ofttimes > it's nut-'n-bolts details _with examples_ that make all the > difference in the world. and this list has a way of filling > that void.</aside> you betcha. of course, i'm in the choir, on this one. (care to join us in a newbiedoc or two?) -- DEBIAN NEWBIE TIP #51 from Will Trillich <[EMAIL PROTECTED]> : Interested in CUSTOMIZING MUTT to work the way you'd like? Visit Tom Gilbert's site at http://linuxbrit.co.uk/mutt/ and download his .muttrc to your home directory (save it under a different name if you're paranoid like I am, then tell mutt ":source file/path/here" to give it a whirl). Wow! Also see http://newbieDoc.sourceForge.net/ ...