On 10/26/19 8:38 AM, Rich Shepard wrote:
> Before my old server died I ran pg_dumpall on the database there and copied
> that to my new server. The old database was postgresql-10 and the new
> one is
> postgresql-11.5.
>
> Am I correct that I can run 'pgsql -f <filename>.sql' and overwrite the
> existing databases with the newer data?
That depends on how you ran pg_dumpall. For instance did you use -c?:
https://www.postgresql.org/docs/11/app-pg-dumpall.html
>
> Checking the database names in both I see that I mistakenly used hyphens
> rather than underscores in one database name. I can change that in the .sql
> file but have not before learned how/whether I can change a database name
> using psql. What's the best approach to changing the existing hypephenated
> name?
This?:
https://www.postgresql.org/docs/11/sql-alterdatabase.html
ALTER DATABASE name RENAME TO new_name
>
> TIA,
>
> Rich
>
>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com