i have installed postgres 8.3, i entered test as the password while the installation...my problem is that each time i try to access the local database...each time i enter the password...it say database connecting failed...i have tried to change the password via command line but it does not work...even tried to change the configuration file...it does not work...is there any way out for me to make the database work? thanks for your reply...
Password in postgres 8.3 not working
2.7k views Asked by cheerag At
2
There are 2 answers
0
SO Stinks
On
In addition to the comment about editing pg_hba.conf, I also had to set a password for myself like in this thread
http://ubuntuforums.org/showthread.php?t=388632
using
ALTER USER postgres WITH ENCRYPTED PASSWORD 'yourhardtoguesspassword';
Related Questions in DATABASE
- How can I determine if a video has just finished using expo.video? ReactNative/Expo.io
- Unknown named Module, using component will receive props to update an image
- Video is still playing when i navigate to another layout
- Error running adb: Error running app. Error: Activity not started, unable to resolve Intent
- Video playlist issue (when one video ends, the next video plays beginning from the length of previous vid) Expo/React Native
- Why is my function being called infinitely? (react-native/expo)
- Are silent Expo push-notifications possible?
- Change navigation bar color
- Set up different language for iOS app using react-native and expo
- Using Animated.Flatlist and Animated.ScrollView to animate an Animated.View is not smooth
Related Questions in POSTGRESQL
- How can I determine if a video has just finished using expo.video? ReactNative/Expo.io
- Unknown named Module, using component will receive props to update an image
- Video is still playing when i navigate to another layout
- Error running adb: Error running app. Error: Activity not started, unable to resolve Intent
- Video playlist issue (when one video ends, the next video plays beginning from the length of previous vid) Expo/React Native
- Why is my function being called infinitely? (react-native/expo)
- Are silent Expo push-notifications possible?
- Change navigation bar color
- Set up different language for iOS app using react-native and expo
- Using Animated.Flatlist and Animated.ScrollView to animate an Animated.View is not smooth
Related Questions in PASSWORD-RECOVERY
- How can I determine if a video has just finished using expo.video? ReactNative/Expo.io
- Unknown named Module, using component will receive props to update an image
- Video is still playing when i navigate to another layout
- Error running adb: Error running app. Error: Activity not started, unable to resolve Intent
- Video playlist issue (when one video ends, the next video plays beginning from the length of previous vid) Expo/React Native
- Why is my function being called infinitely? (react-native/expo)
- Are silent Expo push-notifications possible?
- Change navigation bar color
- Set up different language for iOS app using react-native and expo
- Using Animated.Flatlist and Animated.ScrollView to animate an Animated.View is not smooth
Related Questions in PGADMIN
- How can I determine if a video has just finished using expo.video? ReactNative/Expo.io
- Unknown named Module, using component will receive props to update an image
- Video is still playing when i navigate to another layout
- Error running adb: Error running app. Error: Activity not started, unable to resolve Intent
- Video playlist issue (when one video ends, the next video plays beginning from the length of previous vid) Expo/React Native
- Why is my function being called infinitely? (react-native/expo)
- Are silent Expo push-notifications possible?
- Change navigation bar color
- Set up different language for iOS app using react-native and expo
- Using Animated.Flatlist and Animated.ScrollView to animate an Animated.View is not smooth
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Often people cannot connect to postgres with a password because it is configured by default to use ident authentication for local connections. Try switching to the postgres system account and connecting with that username. If you get in without a password you're configured for ident. You can also check the authentication methods in pg_hba.conf.
If you want to switch to using passwords for local connections, you can modify the setting in pg_hba.conf. At the bottom of the file there's a section like this:
You can see on the second "local" line I have changed my setting to use md5 authentication instead of ident sameuser. That allows me to log in as any database user from my system account by using the correct password. If you make the same change and restart postgres that might solve your problem.
Be careful not to change the first "local" line. The postgres user is the super user and if you change that authentication mechanism you may not be able to get in.