I successfully compiled/built pg 8.1.9 using --with-openssl on a Mac. I modified the startup config files to enable ssl. Server starts without problems, but when I try to require SSL from pgAdminIII, I get 'server does not support SSL'.
Postgres user The user account named postgres (by default) created by the installer is actually a macOS user account. Apple allows deleting a user account in the more recent versions of macOS: System Preferences Users & Groups - button in list, after authenticating with padlock icon in lower corner.
In older macOS versions that do not delete user accounts, you may be able to. Every other trace of Postgres can be removed. Backup/Export Of course, first with a tool like pgBackup. And/or export your data. Uninstaller app The installer app provided by EnterpriseDB does install an app named Uninstaller. Find it in the Postgres folder, probably located at the root Library folder (not the Library folder in your home folder).
/Library/PostgreSQL/10 Run that uninstaller app, and supply your macOS system password. After the run, the data folder remains as that is owned by the postgres user rather than your regular macOS user. The uninstaller app reminds you of this fact. /Library/PostgreSQL/10/data data folder Select that data folder in the Finder, and choose File Move to trash.
When prompted, provide your own macOS user account password. Delete that outer Postgres folder(s) that contained data. Applications folder Remove the PostgreSQL 10 folder in your Applications folder if it remains. Again, provide your own macOS user account password.
If you're using vanilla OS X, you probably have not enabled the root user - which is Mac OS X default behavior for a reason. Rather than launching a giant project to find out how to enable root, just use Terminal and enter 'sudo su'. You will get the usual sudoers lecture (engrave it on your soul, even if you have only one user), and you will find yourself staring at the root prompt. God help you. This trick is slightly less omnipotent than actually logging in as root, but the difference between disaster and catastrophe is not worth mentioning. Be sure to enter 'exit' after you have accomplished the precisely exact one single thing you needed to masquerade as root for.
Now for the stupid part: I forgot the password for that user. I installed it using FINK and everything went well as I recall. Do I need to uninstall the software? If so, is there an easy way to do this?OS X is Unix (or Unix-like), right? The classic way around this is sign on as root and then use passwd to change the password for user postgres. I've forgotten the postgres user password myself as have probably half the people on this list! Brew -(end of broadcast)- TIP 5: Have you checked our extensive FAQ?
Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' On Sunday, February 23, 2003, at 03:54 PM, David C.Oshel wrote: If you're using vanilla OS X, you probably have not enabled the root user - which is Mac OS X default behavior for a reason. Rather than launching a giant project to find out how to enable root, just use Terminal and enter 'sudo su'. You will get the usual sudoers lecture (engrave it on your soul, even if you have only one user), and you will find yourself staring at the root prompt. God help you. This trick is slightly less omnipotent than actually logging in as root, but the difference between disaster and catastrophe is not worth mentioning.
Postgresql: Re: Postgres 8.1 For Mac Mac
Be sure to enter 'exit' after you have accomplished the precisely exact one single thing you needed to masquerade as root for. Now for the stupid part: I forgot the password for that user. I installed it using FINK and everything went well as I recall. Do I need to uninstall the software? If so, is there an easy way to do this?OS X is Unix (or Unix-like), right?
The classic way around this is sign on as root and then use passwd to change the password for user postgres. I've forgotten the postgres user password myself as have probably half the people on this list! Brew -(end of broadcast)- TIP 5: Have you checked our extensive FAQ? Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster Robert Prather @mobile.att.net - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein Robert Prather @mobile.att.net.
On Sunday, February 23, 2003, at 03:54 PM, David C.Oshel wrote: If you're using vanilla OS X, you probably have not enabled the root user - which is Mac OS X default behavior for a reason. Rather than launching a giant project to find out how to enable root, just use Terminal and enter 'sudo su'. You will get the usual sudoers lecture (engrave it on your soul, even if you have only one user), and you will find yourself staring at the root prompt. God help you. This trick is slightly less omnipotent than actually logging in as root, but the difference between disaster and catastrophe is not worth mentioning.
Be sure to enter 'exit' after you have accomplished the precisely exact one single thing you needed to masquerade as root for. Now for the stupid part: I forgot the password for that user.
I installed it using FINK and everything went well as I recall. Do I need to uninstall the software?
If so, is there an easy way to do this?OS X is Unix (or Unix-like), right? The classic way around this is sign on as root and then use passwd to change the password for user postgres. I've forgotten the postgres user password myself as have probably half the people on this list! Brew -(end of broadcast)- TIP 5: Have you checked our extensive FAQ?
Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster Robert Prather @mobile.att.net - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein Robert Prather @mobile.att.net -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' On Sunday, February 23, 2003, at 03:54 PM, David C.Oshel wrote: If you're using vanilla OS X, you probably have not enabled the root user - which is Mac OS X default behavior for a reason.
Rather than launching a giant project to find out how to enable root, just use Terminal and enter 'sudo su'. You will get the usual sudoers lecture (engrave it on your soul, even if you have only one user), and you will find yourself staring at the root prompt. God help you. This trick is slightly less omnipotent than actually logging in as root, but the difference between disaster and catastrophe is not worth mentioning. Be sure to enter 'exit' after you have accomplished the precisely exact one single thing you needed to masquerade as root for. Now for the stupid part: I forgot the password for that user.
I installed it using FINK and everything went well as I recall. Do I need to uninstall the software? If so, is there an easy way to do this?OS X is Unix (or Unix-like), right? The classic way around this is sign on as root and then use passwd to change the password for user postgres.
I've forgotten the postgres user password myself as have probably half the people on this list! Brew -(end of broadcast)- TIP 5: Have you checked our extensive FAQ?
Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster Robert Prather @mobile.att.net - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.'
Einstein Robert Prather @mobile.att.net -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein Robert Prather @mobile.att.net.
Adam Witney Did you install this from the apple web site? I notice that sets up a user 'postgre' If so maybe take a look at the Server Logistics web page as they are the people providing this distribution. For PostgreSQL 7.2.1 on OS X 10.1 For PostgreSQL 7.3 on OS X 10.2 adam - This message has been scanned for viruses. On Sunday, February 23, 2003, at 03:54 PM, David C.Oshel wrote: If you're using vanilla OS X, you probably have not enabled the root user - which is Mac OS X default behavior for a reason. Rather than launching a giant project to find out how to enable root, just use Terminal and enter 'sudo su'.
You will get the usual sudoers lecture (engrave it on your soul, even if you have only one user), and you will find yourself staring at the root prompt. God help you. This trick is slightly less omnipotent than actually logging in as root, but the difference between disaster and catastrophe is not worth mentioning. Be sure to enter 'exit' after you have accomplished the precisely exact one single thing you needed to masquerade as root for.
Now for the stupid part: I forgot the password for that user. I installed it using FINK and everything went well as I recall. Do I need to uninstall the software? If so, is there an easy way to do this?OS X is Unix (or Unix-like), right? The classic way around this is sign on as root and then use passwd to change the password for user postgres. I've forgotten the postgres user password myself as have probably half the people on this list! Brew -(end of broadcast)- TIP 5: Have you checked our extensive FAQ?
Postgresql Client Mac
Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster Robert Prather @mobile.att.net - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.' Einstein Robert Prather @mobile.att.net -(end of broadcast)- TIP 4: Don't 'kill -9' the postmaster - David C. Oshel mailto:dcoshel@inav.net Cedar Rapids, Iowa ``Raffiniert ist der Herrgot, aber boshaft ist er nicht.'
Einstein -(end of broadcast)- TIP 5: Have you checked our extensive FAQ? - This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.