 | |
Re: free database for Mac OS X?
comp.databases.postgresql comp.databases.postgresql
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: free database for Mac OS X? -
11-25-2011
, 09:08 PM
|
On Sam 26 novembre 2011, 00:42, justaguy <do... (AT) yahoo (DOT) com> wrote: Thanks Matt, yes, it appears that PostgreSQL is a desirable option now, not sure about how easy or difficult it is to install and configure and run on various Mac OS X computers... I can't tell you such a thing (i'm using a postgresql packaged by an accounting software) but after a quick look on the postgresql website there's a Mac OS X installer there[1] which would be simpler than compiling the sources if you're not familiar with the Xcode/devtools thingies. Btw, is it able to import / migrate an Access db? According to Postgresql's wiki there are some solutions[2]. Best, [1] <http://www.postgresql.org/download/macosx [2] <http://wiki.postgresql.org/wiki/Conv...atabases_to_Po... PS. i'm crossposting to comp.databases.postgresql and comp.sys.mac.system and set the followup to comp.databases.postgresql as those are english spoken newsgroups and your question is more postgresql related. PPS. grab a *real* newsreader for Usenet; Google's interface really s*cks -- echo 'hfr... (AT) flevhf (DOT) bet' | \ tr '[a-z]' '[n-za-m]' |
minutes to install to Windows 7 (prompted with fatal error) and yet
completed installation successfully. It won't start the server.
Rebooted, yes, it started the server, however, the pgAdmin III (mgr
tool) failed to connect to it. Don't know what's going on here...
#2
| |||
| |||
|
|
Thanks for the idea of postgresql, bad experience. It took 10+ minutes to install to Windows 7 (prompted with fatal error) and yet completed installation successfully. It won't start the server. Rebooted, yes, it started the server, however, the pgAdmin III (mgr tool) failed to connect to it. Don't know what's going on here... |
'*' and restart the service.
--
http://mgogala.byethost5.com
#3
| |||
| |||
|
|
On Fri, 25 Nov 2011 19:08:07 -0800, justaguy wrote: Thanks for the idea of postgresql, bad experience. It took 10+ minutes to install to Windows 7 (prompted with fatal error) and yet completed installation successfully. It won't start the server. Rebooted, yes, it started the server, however, the pgAdmin III (mgr tool) failed to connect to it. Don't know what's going on here... Probably the listener parameter in postgresql.conf. You need to set it to '*' and restart the service. |
I think you mean listen_addresses. But you are joking about *, aren't you?
#4
| |||
| |||
|
|
On Sun, 27 Nov 2011 17:33:28 +0000, Mladen Gogala wrote: On Fri, 25 Nov 2011 19:08:07 -0800, justaguy wrote: Thanks for the idea of postgresql, bad experience. It took 10+ minutes to install to Windows 7 (prompted with fatal error) and yet completed installation successfully. It won't start the server. Rebooted, yes, it started the server, however, the pgAdmin III (mgr tool) failed to connect to it. Don't know what's going on here... Probably the listener parameter in postgresql.conf. You need to set it to '*' and restart the service. Mladen, I think you mean listen_addresses. But you are joking about *, aren't you? |
addresses. This is what I have in my postgresql.conf:
listen_addresses = '*'
#listen_addresses = 'localhost' # what IP address(es) to listen
on;
# comma-separated list of
addresses;
# defaults to 'localhost', '*' =
all
# (change requires restart)
#port = 5432 # (change requires restart)
max_connections = 100 # (change requires restart)
It works well, I don't see any problems with that setting.
--
http://mgogala.byethost5.com
#5
| |||
| |||
|
|
Thanks for the idea of postgresql, bad experience. It took 10+ minutes to install to Windows 7 (prompted with fatal error) and yet completed installation successfully. It won't start the server. Rebooted, yes, it started the server, however, the pgAdmin III (mgr tool) failed to connect to it. Don't know what's going on here... Probably the listener parameter in postgresql.conf. You need to set it to '*' and restart the service. |
connections (although OP didn't tell us whether it was a local connection
or not).
Maybe if we see the relevant parts of postgresql.conf and pg_hba.conf,
know what was entered into pgAdmin III and what the error message was,
we could do more than just guess.
Yours,
Laurenz Albe
#6
| |||
| |||
|
|
I don't know about Windows, but the default setting should allow local connections (although OP didn't tell us whether it was a local connection or not). |
connection, even if the host is defined as localhost. I've hit that,
although not on Windows. I don't run databases on Windows.
--
http://mgogala.byethost5.com
#7
| |||
| |||
|
|
On Mon, 28 Nov 2011 09:41:12 +0100, Laurenz Albe wrote: I don't know about Windows, but the default setting should allow local connections (although OP didn't tell us whether it was a local connection or not). PgAdmin usually requires the user to add host. That means it's a TCP connection, even if the host is defined as localhost. I've hit that, although not on Windows. I don't run databases on Windows. |
$ grep listen_addresses /postgres/cvs/dbhome/postgresql.conf
#listen_addresses = 'localhost' # what IP address(es) to listen on;
$ /postgres/cvs/pg92/bin/pg_ctl start -D /postgres/cvs/dbhome
server starting
$ /postgres/cvs/pg92/bin/psql -h localhost -p 5432 -U postgres -d postgres
psql (9.2devel)
Type "help" for help.
postgres=# SHOW listen_addresses;
listen_addresses
------------------
localhost
(1 row)
Yours,
Laurenz Albe
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.