Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.postgresql > #277 > unrolled thread

Re: free database for Mac OS X?

Back to article view | Back to comp.databases.postgresql

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: free database for Mac OS X? Matt <hfrarg@syrius.org.invalid> - 2011-11-26 01:54 +0100
    Re: free database for Mac OS X? justaguy <donli@yahoo.com> - 2011-11-25 19:08 -0800
      Re: free database for Mac OS X? Mladen Gogala <gogala.mladen@gmail.com> - 2011-11-27 17:33 +0000
        Re: free database for Mac OS X? HoneyMonster <someone@someplace.invalid> - 2011-11-27 19:43 +0000
          Re: free database for Mac OS X? Mladen Gogala <gogala.mladen@gmail.com> - 2011-11-28 00:00 +0000
        Re: free database for Mac OS X? "Laurenz Albe" <invite@spam.to.invalid> - 2011-11-28 09:41 +0100
          Re: free database for Mac OS X? Mladen Gogala <gogala.mladen@gmail.com> - 2011-12-01 21:53 +0000
            Re: free database for Mac OS X? "Laurenz Albe" <invite@spam.to.invalid> - 2011-12-02 09:40 +0100

#277 — Re: free database for Mac OS X?

On Sam 26 novembre 2011, 00:42,
justaguy <donli@yahoo.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/Converting_from_other_Databases_to_PostgreSQL>

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 'hfrarg@flevhf.bet' | \
tr '[a-z]' '[n-za-m]'

[toc] | [next] | [standalone]

#280

On Nov 25, 7:54 pm, Matt <hfr...@syrius.org.invalid> wrote:
> On Sam 26 novembre 2011, 00:42,
>
> justaguy <do...@yahoo.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/Converting_from_other_Databases_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...@flevhf.bet' | \
> tr '[a-z]' '[n-za-m]'

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...

[toc] | [prev] | [next] | [standalone]

#281

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.



-- 
http://mgogala.byethost5.com

[toc] | [prev] | [next] | [standalone]

#282

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?

[toc] | [prev] | [next] | [standalone]

#283

On Sun, 27 Nov 2011 19:43:14 +0000, HoneyMonster wrote:

> 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?

No, I am not joking. That directs Postgres to listen on all available 
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

[toc] | [prev] | [next] | [standalone]

#284

Mladen Gogala 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 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).

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 

[toc] | [prev] | [next] | [standalone]

#287

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.



-- 
http://mgogala.byethost5.com

[toc] | [prev] | [next] | [standalone]

#288

Mladen Gogala wrote:
> 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.

Yes, but the default setting allows localhost (TCP) connections:

$ 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 

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.postgresql

csiph-web