Re: Repeat: Problem with Postgresql database
On Sat, Jul 21, 2001 at 06:42:46AM +, 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.) asideman'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/ ...
Re: Repeat: Problem with Postgresql database
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. asideman'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 so, thx, again. bentley taylor. //
Re: Repeat: Problem with Postgresql database
On Wed, Jul 11, 2001 at 09:04:01PM -0400, Brian Schramm wrote: I just upgraded from potato to Progeny Debian. The upgrade went fairly smooth (thanks Progeny) and the system seems to be working well. My 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? can you get in via the postgres superuser? (su to root, then su to postgres). maybe try createuser from the postgres account. just guessing... -- DEBIAN NEWBIE TIP #21 from Will Trillich [EMAIL PROTECTED] : Looking to configure your Debian NETWORK SETTINGS? Look at the file /etc/network/interfaces (try man interfaces for more info). Then ifup -a to reload your settings, and ifconfig to display them. (Also check out apt-get install ipmasq!) Also see http://newbieDoc.sourceForge.net/ ...
Re: Repeat: Problem with Postgresql database
I tryed that. I can get in by the postgres user but cannot create a user from there. It does not give me an error message but does not create the user eather. Brian Brian Schramm [EMAIL PROTECTED]ICQ 104442754 AIM schrammbrian www.linuxexpert.org On Fri, 13 Jul 2001, will trillich wrote: On Wed, Jul 11, 2001 at 09:04:01PM -0400, Brian Schramm wrote: I just upgraded from potato to Progeny Debian. The upgrade went fairly smooth (thanks Progeny) and the system seems to be working well. My 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? can you get in via the postgres superuser? (su to root, then su to postgres). maybe try createuser from the postgres account. just guessing... -- DEBIAN NEWBIE TIP #21 from Will Trillich [EMAIL PROTECTED] : Looking to configure your Debian NETWORK SETTINGS? Look at the file /etc/network/interfaces (try man interfaces for more info). Then ifup -a to reload your settings, and ifconfig to display them. (Also check out apt-get install ipmasq!) Also see http://newbieDoc.sourceForge.net/ ... -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of unsubscribe. Trouble? Contact [EMAIL PROTECTED]
Re: Repeat: Problem with Postgresql database
On Fri, Jul 13, 2001 at 08:43:05AM -0400, Brian Schramm wrote: I tryed that. I can get in by the postgres user but cannot create a user from there. It does not give me an error message but does not create the user eather. if you can get into the database as user postgres from the command line, you should be able to do what you need, as far as the database is concerned: postgres$ psql mydb mydb=# \h create user you may need to check the host-based access methods in /etc/postgresql/pg_hba.conf as well... # force everyone from everywhere to supply a password hostall0.0.0.00.0.0.0 crypt -- DEBIAN NEWBIE TIP #23 from Will Trillich [EMAIL PROTECTED] : Wondering what you should BACK UP -- and what you shouldn't? Here's a how I do it written by a debian-user regular, Karsten Self: http://kmself.home.netcom.com/Linux/FAQs/backups.html This is a frequent topic on debian-user; check the archives at lists.debian.org for other backup approaches -- search for backup scheme. Also see http://newbieDoc.sourceForge.net/ ...
Repeat: Problem with Postgresql database
I just upgraded from potato to Progeny Debian. The upgrade went fairly smooth (thanks Progeny) and the system seems to be working well. My 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? Thanks Brian Brian Schramm [EMAIL PROTECTED]ICQ 104442754 AIM schrammbrian www.linuxexpert.org