You should now have a new database and user on the Postgres server, and the user should have full privileges on the database. Replace databasename with the name of the database, and username with the name of the user. psql -hostxxxxxxx -port5432 -usernamepostgres -password. GRANT ALL PRIVILEGES ON DATABASE databasename TO username To Creating a user in postgres, Creating a database under a different user in postgres, Creating a schema under a different database with new user in postgres, Login as Postgres-user.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |