Sample Header Ad - 728x90

Create pgSQL DBs on different drives in ms windows

0 votes
1 answer
1408 views
I have PostgreSQL 15 installed on a Windows Server 2019 Standard VM. I've installed pgSQL using the default configuration on the C:\ drive. I'm currently using the default data directory of C:\...\data. I also have a D:\ drive that I would like to create pgSQL DBs on. I don't want to move the default ...\data directory but only want to create new DBs in the D:\PostgreSQLData directory, which is on the same VM. I didn't see any solution in my initial search on this site. If such solutions already exist here or elsewhere, please send me the link. Otherwise, what are the steps to do this?
Asked by Larry Layne (1 rep)
Jan 11, 2023, 06:17 PM
Last activity: Nov 17, 2024, 08:01 PM