Moving from Windows to Ubuntu - Have a couple of questions

Jennifer Trey schrieb:

I am in the process of switching to Ubuntu, and I have a couple of
question to get started. I installed pgadmin and postgre through the
Synaptic Package Manager. I am unfamiliar with the console so I prefer
to use pgAdmin to set things up.

congratulations for switching ;-). You should start to get familar with the console
because a lot of things are much easier using the console. Especially configuring the
PostgreSQL and using psql (the command line interface)

Opening pgAdmin I see Servers(0) .. I am trying to add a server and
filled out things to match the windows properties but can't get it to work.
On the Service part, windows says postgresql-8.3 but on Ubuntu it is
empty. I tried to put the same thing there as well, but also with no
success. I am guessing I need to do something before that.. the ideas is
that I will create a DB later and use my windows backup and restore.

You have to edit two files at least:

/etc/postgresql/8.3/main/pg_hba.conf

This ist the file for setting the authentication for your cluster. Please refer to this
part of the documentation:

http://www.postgresql.org/docs/8.3/interactive/auth-pg-hba-conf.html

And probably you also have to edit:

/etc/postgresql/8.3/main/postgresql.conf

Please read the documentation here:

http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html

Most important is listen_adresses ... hm, I think the defaults should be ok to get started.

Basically you should be able to connect to the server by setting this in pg_hba.conf:

# TYPE DATABASE USER CIDR-ADDRESS METHOD
local all all trust

But take care - this should only be set for testing purpose.

Is the server running? Type this in the command line:

$ /etc/init.d/postgresql-8.3 status

If you get something like this

8.3 main 5432 online postgres /var/lib/postgresql/8.3/main \
/var/log/postgresql/postgresql-8.3-main.log

PG is running ...

Hope that helps for the start

Cheers

Andy

Thanks, I got help from a friend and got it to work. I think postgre was
running already but not sure what else he did.. i think that he altered the
password among other things.
How should one port the config file from windows to linux? I am guessing
replacing the .conf file is not an option :O .. the hard ware is the same,
should I just go through them one after one?

- Jen

Jennifer Trey wrote:

Thanks, I got help from a friend and got it to work. I think postgre was
running already but not sure what else he did.. i think that he altered the
password among other things.

It might well have been the case that the "postgres" user didn't have a
password. Unix-based systems offer something called "ident" which may
well have been the default.

How should one port the config file from windows to linux? I am guessing
replacing the .conf file is not an option :O .. the hard ware is the same,
should I just go through them one after one?

There shouldn't be that many differences - although, obviously any paths
will be different.

If you feel like learning some command-line stuff you could try:
dos2unix /path/to/windows/postgresql.conf

  diff -b /path/to/windows/postgresql.conf 
/path/to/ubuntu/postgresql/conf | less

That's two commands, each on a single line. The first one gives you unix
line-endings in the config file. The second finds differences (diff) and
feeds them to a scrollable file-viewer ("less", which is a sequel to
"more" because "less is more"). Use "q" to quit.

--
Richard Huxton
Archonet Ltd

On 2009-07-28, Jennifer Trey <jennifer.trey@gmail.com> wrote:

--001636c5a2d8cdcb9c046fc47cee
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,
I have been running PostgreSQL 8.3 for a while now and was installed through
the standard Windows installer and everything has been working great :)

I am in the process of switching to Ubuntu, and I have a couple of question
to get started. I installed pgadmin and postgre through the Synaptic Package
Manager. I am unfamiliar with the console so I prefer to use pgAdmin to set
things up.

One nice thing about the console is you can cut and paste to it,
Gui instructions tend to involve lots of reading descriptions fine
motor skills and and squinting at pictures.

Opening pgAdmin I see Servers(0) .. I am trying to add a server and filled
out things to match the windows properties but can't get it to work.
On the Service part, windows says postgresql-8.3 but on Ubuntu it is empty.
I tried to put the same thing there as well, but also with no success. I am
guessing I need to do something before that.. the ideas is that I will
create a DB later and use my windows backup and restore.

Postgres ships in most distributions with external network connections
turned off. one option is to install pgadmin on the ubuntu machine also.

The other is to turn on the networking, you probably only want to
enable (part of) your LAN.