Fedora Linux Support Community & Resources Center
  #1  
Old 16th July 2017, 04:40 AM
Doug Hutcheson Offline
Registered User
 
Join Date: Jun 2009
Location: Queensland
Posts: 277
linuxfedorachrome
postgresql problems after upgrade to F26

I have a very strange problem. I ran the dnf upgrade to 26 which worked OK after I reclaimed some space on the root partition. I downloaded and ran postgresql-upgrade, which was successful according to the log.

Now, I cannot attach to postgresql using PgAdminIII. Also, I can run psql <a valid database name> and this works, but then running '\dt' returns no table names.

I have run a pg_dumpall from the running instance and all my tables and data are there.

What am I doing wrong? (Beats head against wall - again.)

later ...

I can get PgAdminIII to connect only if I set the security level to 'trust'. Still can't get LibreOffice to connect via sdbc, but I'll keep trying.

Having security at 'trust' level is not a real solution, but it lets me keep working until the correct solution is arrived at.

Last edited by Doug Hutcheson; 16th July 2017 at 09:42 AM.
Reply With Quote
Reply

Tags
f26, postgresql, problems, upgrade

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
After upgrade to 26 I cannot access postgresql data Doug Hutcheson Installation, Upgrades and Live Media 2 20th July 2017 02:00 AM
Postgresql problem after upgrade F16 to F17 reader69 Using Fedora 2 11th July 2012 10:58 AM
[Q] FC4 - PostgreSQL Data Upgrade TheEdge Servers & Networking 0 28th June 2005 11:17 AM
PostgreSQL unable to start after last upgrade fjleal Servers & Networking 0 18th December 2004 03:04 PM


Current GMT-time: 18:58 (Thursday, 27-07-2017)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat