Re: How to rename current database?

Поиск
Список
Период
Сортировка
От Scott Whitney
Тема Re: How to rename current database?
Дата
Msg-id BN7PR11MB2659E2E831040F10EAFB694FA7990@BN7PR11MB2659.namprd11.prod.outlook.com
обсуждение исходный текст
Ответ на Re: How to rename current database?  (Steven Crandell <steven.crandell@gmail.com>)
Ответы Re: How to rename current database?  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin
Дерево обсуждения

Hang on. You're baffled that you have to sign up for a mailing list on which experts reside because you lack the expertise to do something?


I mean, you can't figure it out on your own, so you're offended and baffled that you have to come to a community of people with enough good will and time on their hands to offer you free advice on resolving your problem?


That's not the kind of attitude that's going to garner you a whole heckuva lot of help.


Cheers.


From: Steven Crandell <steven.crandell@gmail.com>
Sent: Wednesday, May 9, 2018 3:09 AM
To: Sven Delle
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: How to rename current database?
 

On Wed, May 9, 2018 at 12:24 AM, Sven Delle <svdellepude@gmail.com> wrote:
I’m baffled that I have to sign up for a mailing list because I’m absolutely unable to figure out from the interface of pgAdmin 4 how to rename a given database?

I’m going to the properties of the database to rename it, but get an error: ERROR: current database cannot be renamed.

Hmm, I guess it’s because it’s currently running, fine – I get that. But then, HOW THE HOLY CRAP DO I STOP THE DATABASE SO I CAN RENAME IT!?!?!?!?!?!?!?!!?!!?!?

Horrible experience from a user perspective.

How do I rename a current database in pgAdmin?

The docs are useless ...


Here's a link to the documentation that describes how to rename a database.
https://www.postgresql.org/docs/current/static/sql-alterdatabase.html
I think you'll find that it has all the information you're looking for.
That said, if you feel something is missing you can propose changes or additions to help make the documentation better.

Keep in mind that pgadmin is a tool that can be used when interacting with a postgresql database, it is by no means required to perform database administration tasks.
Personally, I prefer psql, which is also well documented here:
https://www.postgresql.org/docs/current/static/app-psql.html

You may have better luck with your pgadmin questions on the pgadmin mailing list here:
https://www.pgadmin.org/support/list/






Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com

p 512.834.8888 
f 512-834-8858 

Do you receive our promotional emails? Click here or visit http://journyx.com/communication-preferences to unsubscribe.

В списке pgsql-admin по дате отправления:

Предыдущее
От: JaeWon Lee
Дата:
Сообщение: Can I synchronize two master DB clusters using logical replication?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: How to rename current database?