Re: postgresql11-devel RPM is missing from "Direct RPM downloads"
Hi Dimiry, On 04/06/2019 23:49, Dmitry O Litvintsev wrote: > Where can I find postgresq11-devel RPM ? > [...] > https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/ have you looked under the letter "P" in your first link? There you can find the -devel package. https://yum.postgresql.org/11/redhat/rhel-7-x86_64/repoview/letter_p.group.html Cheers! Jakub
Re: Postgresql-11 confusing situtation
Hi Domen, On 05/06/2019 14:46, Domen Šetar wrote: > Systemctl shows that database is dead, but it is actually running. > > Can someone explain this behavioure? As others pointed out - this is due to bypassing of systemd altogether in order to start the database proces. If you check the configuration of the service under /usr/lib/systemd/system/postgresql-10.service you can inspect further how this work (exactly what type of notification is used). More on the types of services and the way they notify systemd can be found here: https://www.freedesktop.org/software/systemd/man/systemd.service.html Cheers! Jakub
Re: Need a DB layout gui
Hello! On 25/06/2019 00:25, David Gauthier wrote: > I've been poking > around > https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreSQL_GUI_Tools to > see if there is anything that can read PG metadata in and display it > graphically in a gui. You know, the kind of picture that is 1 block per > table with 1->many arrows connecting up the primary/foreign keys of > different tables. SQL Power Architect looked promising, but fails to do > the linkage for some PK-FK relationships (buggy?) . > > Any suggestions on what might do this? Have you tried pgModeler[1]? The current limitation is that stable version works only up to PostgreSQL 10, as far as I know. But it is actively maintained, and I guess that support for PostgreSQL 11/12 is available in the beta build, which means it will be available soon. [1]: http://www.pgmodeler.io/ Cheers, Jakub Olczyk
