![]() The second record establishes a mapping between the example Windows admin and the default postgres user to ensure commands using the default user are authenticated. The first record describes our example Windows admin, exampleadmin, and makes mention of this machine's own name, example-vm, so naturally this first line will vary to match your environment's Windows user and machine name. We'll be modifying two files in C:\Program Files\PostgreSQL\11\data.Įdit "pg_nf" and establish 5 records at the bottom of the file (see below). Open File Explorer to C:\Program Files\PostgreSQL\11\dataĪt this point, 'exampleadmin' exists, but we need to configure postgres to make use of it in SSPI mode. Under "General", key in the Windows username you are logged in as (in this case ' exampleadmin'), and under "Privileges" checked all to Yes. Under the expanded "Servers" node, drill down into "PostgreSQL 11" and then right-click on "Login / Group Roles" and select "Create". Create Administrative Account in PostgresĮxpand "Servers" on the left hand side. You will be prompted for a master password, and can use the same password used during Postgres installation for the default user 'postgres'. Launch pgAdmin, which was installed with Postgres. # Use the output of this command for throughout the next Step 2. # Use the output of this command for "exampleadmin" throughout the next steps
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |