Re: psql on Fedora 19

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Am 04.07.2013 00:58, schrieb Roger:
I successfully fresh installed Fedora19 , works a treat, very good very fast operating system.
Updated everything and installed rvm rails 4 and postgresql.

Tryng to get into postgres with psql postgres postgres and I get "could not connect to server: No such file or
directory, Is teh server running locally, etc
I reckon I've missed something in the installation but do not know what.
Can someone please point me in the right direction
hardly because you do not provide *any* information
about your postgre-sdql configuration nor do you provide
the output of "systemctl status" or "ps aux" to make at
least sure postgresql is running at all

http://www.catb.org/esr/faqs/smart-questions.html#beprecise


Forgot that I also had to install postgresql-server which solved the above.
sudo service postgresql start reports: Redirecting to /bin/systemctl/start postgresql.service

su -l postgres should allow me to createuser but requires password - my user nor root passwords do not authenticate.
sudo -l postges with my user password does not authenticate.

systemctl status reports:
NetworkManager.service - Network Manager

Jul 04 08:49:15 localhost.localdomain polkitd[514]: Registered Authentication Agent for unix-session:1 (system bus name :1.68 [/usr/bin/gnome-shell], object path /org/freedesktop/PolicyKit1/AuthenticationAgent, locale en_US.utf8)
postgresql.service -> '/org/freedesktop/systemd1/unit/postgresql_2eservice'

postgresql.service - PostgreSQL database server
   Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled)
   Active: active (running) since Thu 2013-07-04 09:03:02 EST; 13min ago
 Main PID: 1984 (postgres)
   CGroup: name=systemd:/system/postgresql.service
           ├─1984 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432
           ├─1985 postgres: logger process
           ├─1987 postgres: checkpointer process
           ├─1988 postgres: writer process
           ├─1989 postgres: wal writer process
           ├─1990 postgres: autovacuum launcher process
           └─1991 postgres: stats collector process

Jul 04 09:03:02 localhost.localdomain systemd[1]: Started PostgreSQL database server.
rngd.service -> '/org/freedesktop/systemd1/unit/rngd_2eservice'

rngd.service - Hardware RNG Entropy Gatherer Daemon
   Loaded: loaded (/usr/lib/systemd/system/rngd.service; enabled)
Active: failed (Result: exit-code) since Thu 2013-07-04 08:48:33 EST; 28min ago
 Main PID: 454 (code=exited, status=1/FAILURE)
   CGroup: name=systemd:/system/rngd.service

ps aux reports:
postgres 1984 0.0 0.3 223700 8184 ? S 09:03 0:00 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 postgres 1985 0.0 0.0 192080 1208 ? Ss 09:03 0:00 postgres: logger process postgres 1987 0.0 0.0 223700 1436 ? Ss 09:03 0:00 postgres: checkpointer process postgres 1988 0.0 0.0 223700 1440 ? Ss 09:03 0:00 postgres: writer process postgres 1989 0.0 0.0 223700 1212 ? Ss 09:03 0:00 postgres: wal writer process postgres 1990 0.0 0.1 224516 2608 ? Ss 09:03 0:00 postgres: autovacuum launcher process postgres 1991 0.0 0.0 192076 1436 ? Ss 09:03 0:00 postgres: stats collector process


--
users mailing list
users@xxxxxxxxxxxxxxxxxxxxxxx
To unsubscribe or change subscription options:
https://admin.fedoraproject.org/mailman/listinfo/users
Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
Have a question? Ask away: http://ask.fedoraproject.org




[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [EPEL Devel]     [Fedora Magazine]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Desktop]     [Fedora Fonts]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Fedora Sparc]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux