Oh how I wish I were using my trusty MS SQL Server 2005. Unfortunately, one of my clients has sent me a PostgreSQL database and I've got to deal with it.
Now, when I installed Postgres, I was prompted to create a user that would run the process. The box was pre-filled with user: 'postgress'...
I know I don't understand correctly, but doesn't the user "postgres" with the long and overcomplicated encryption string for a password own the process? But isn't he a superuser?
Sincerely,
Discouraged by OpenSource.
I appreciate all of the thoughts offered so far.
Perhaps I am totally backwards, or maybe Postgres really doesn't make any sense.
Where exactly do I do an initdb? (Postgres for Windows) so that I can change the location of where Postgres stores it's databases.
Is this done from the "command...
THANKS! Where do I type these commands? (I'm a novice). I read documentation for Postgres and I read -D this and -S that, but the DOS-like prompt only allows for /a and /y type switches. Is it the same?
Hi. I'm new to Postgres. I'm using the Windows version.
I am trying to restore a database file. All is going well except my system hard drive (c:) is full. How can I change where my database is being stored (I'd like to store it on my e: drive).
Is this done when I CREATE my database, or...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.