Re: [GENERAL] post installation addition of uuid extension

On 08/05/2011 05:26 PM, Tom Lane wrote: > Rob Sargent writes: >> I've inherited some version 9.0 databases which make use of the uuid >> data type but which do not have the uuid-generate-vx() functions. >> These installations are running on openSUSE 11.3 (x86_64) and were >> installed (probably)

Re: [GENERAL] post installation addition of uuid extension

On 08/05/2011 05:26 PM, Tom Lane wrote: > Rob Sargent writes: >> I've inherited some version 9.0 databases which make use of the uuid >> data type but which do not have the uuid-generate-vx() functions. >> These installations are running on openSUSE 11.3 (x86_64) and were >> installed (probably)

Re: [GENERAL] post installation addition of uuid extension

Rob Sargent writes: > I've inherited some version 9.0 databases which make use of the uuid > data type but which do not have the uuid-generate-vx() functions. > These installations are running on openSUSE 11.3 (x86_64) and were > installed (probably) from yast. I've loaded the requisite share-lib

[GENERAL] post installation addition of uuid extension

I've inherited some version 9.0 databases which make use of the uuid data type but which do not have the uuid-generate-vx() functions. These installations are running on openSUSE 11.3 (x86_64) and were installed (probably) from yast. I've loaded the requisite share-libs (also via yast) (/usr/lib64

[GENERAL] post installation addition of uuid extension

I've inherited some version 9.0 databases which make use of the uuid data type but which do not have the uuid-generate-vx() functions. These installations are running on openSUSE 11.3 (x86_64) and were installed (probably) from yast. I've loaded the requisite share-libs (also via yast) (/usr/lib64

Re: [GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

On Thu, 10 Mar 2011, Adrian Klaver wrote: My guess is you did a Postgres client only package install at some point:) Not consciously. When I upgraded from 8.4 to 9.0.1 last December everything moved from /var/lib/pgsql to /usr/local/psql. The build/install date on the executable /bin/psql ma

Re: [GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

On Thursday, March 10, 2011 8:11:37 am Rich Shepard wrote: > On Thu, 10 Mar 2011, Adrian Klaver wrote: > > Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have > > the old psql in your path and it is being found first. > > Adrian, > >Found it. There was an executable /bin

Re: [GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

On Thu, 10 Mar 2011, Adrian Klaver wrote: Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have the old psql in your path and it is being found first. Adrian, Found it. There was an executable /bin/psql in addition to /usr/local/psql/bin/psql. I've no idea how the former

Re: [GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

On Thu, 10 Mar 2011, Adrian Klaver wrote: Your psql binary is from 9.0.1 your server from 9.0.3. Somewhere you have the old psql in your path and it is being found first. Huh! Wonder how that happened. I moved /usr/local/pgsql/ to /usr/local/pgsql.9.0.1 and installed 9.0.3 into /usr/local.

Re: [GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

On Thursday, March 10, 2011 6:54:18 am Rich Shepard wrote: >After carefully following the instructions here: > > I tested the upgrade from the command line. My question is why I still see > a reference to 9.0.1; > > psql

[GENERAL] Post-Upgrade Question: 9.0.1 -> 9.0.3

After carefully following the instructions here: I tested the upgrade from the command line. My question is why I still see a reference to 9.0.1; psql (9.0.1, server 9.0.3) Type "help" for help. One database was created

Re: [GENERAL] Post Install / Secure PostgreSQL

Alan Hodgson wrote: The default setup allows "trust" access which means it trusts local system accounts to login as the same roles in Pg without specifying a password. There's two small inaccuracies with how you're describing this part. First, having "trust" be the default is the case for

Re: [GENERAL] Post Install / Secure PostgreSQL

On 16/09/2010 2:10 AM, Carlos Mennens wrote: postgres=# SELECT * FROM pg_user; Doesn't that show I'm connected to the 'postgres' database and there is a table called 'pg_user' which holds all my PostgreSQL user info? That doesn't make sense to me if the database is empty unless I am missing s

Re: [GENERAL] Post Install / Secure PostgreSQL

Alan Hodgson writes: > On September 15, 2010 11:10:45 am Carlos Mennens wrote: >> Doesn't that show I'm connected to the 'postgres' database and there >> is a table called 'pg_user' which holds all my PostgreSQL user info? >> That doesn't make sense to me if the database is empty unless I am >> mi

Re: [GENERAL] Post Install / Secure PostgreSQL

On 09/15/10 11:10 AM, Carlos Mennens wrote: On Wed, Sep 15, 2010 at 1:43 PM, John R Pierce wrote: the 'postgres' database on your system is empty. this is quite typical, as that database is simply a convenience for the postgres user to have something to log into while doing his administrati

Re: [GENERAL] Post Install / Secure PostgreSQL

On September 15, 2010 11:10:45 am Carlos Mennens wrote: > Doesn't that show I'm connected to the 'postgres' database and there > is a table called 'pg_user' which holds all my PostgreSQL user info? > That doesn't make sense to me if the database is empty unless I am > missing something here. The on

Re: [GENERAL] Post Install / Secure PostgreSQL

On Wed, Sep 15, 2010 at 1:43 PM, John R Pierce wrote: > the 'postgres' database on your system is empty.   this is quite typical, as > that database is simply a convenience for the postgres user to have > something to log into while doing his administrative duties. OK this makes sense and I coul

Re: [GENERAL] Post Install / Secure PostgreSQL

John R Pierce writes: > On 09/15/10 10:00 AM, Carlos Mennens wrote: >> But when if 'cmennens' wants to login to PostgreSQL but not connect to >> any specific database? I know in MySQL you can login to the MySQL >> server CLI but not be attached to any specific database if you want to >> just pee

Re: [GENERAL] Post Install / Secure PostgreSQL

On Wed, Sep 15, 2010 at 10:36 AM, Carlos Mennens wrote: > postgres=# \d > No relations found. > postgres=# \dt > No relations found. > postgres=# \c postgres > psql (8.4.4) > You are now connected to database "postgres". > postgres=# \dt > No relations found. > postgres=# \d try: select current

Re: [GENERAL] Post Install / Secure PostgreSQL

On Wed, Sep 15, 2010 at 1:36 PM, Carlos Mennens wrote: > Thanks but then I am confused why I am getting the following: > You initially connected to the postgres database because you were logging in as the postgres user... > > postgres=# \d > No relations found. > postgres=# \dt > No relations f

Re: [GENERAL] Post Install / Secure PostgreSQL

On 09/15/10 10:36 AM, Carlos Mennens wrote: On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce wrote: no, there is no such state in postgres. you connect and log into a database. connecting to a different database requires closing that connection and opening a new one (which is what the \c comma

Re: [GENERAL] Post Install / Secure PostgreSQL

On Wed, Sep 15, 2010 at 1:34 PM, John R Pierce wrote: > no, there is no such state in postgres.  you connect and log into a > database.  connecting to a different database requires closing that > connection and opening a new one (which is what the \c command does in > psql). Thanks but then I am

Re: [GENERAL] Post Install / Secure PostgreSQL

On 09/15/10 10:00 AM, Carlos Mennens wrote: But when if 'cmennens' wants to login to PostgreSQL but not connect to any specific database? I know in MySQL you can login to the MySQL server CLI but not be attached to any specific database if you want to just peek around and do basic administrative

Re: [GENERAL] Post Install / Secure PostgreSQL

Thanks all for the help! I have a much better understanding now of how user accounts are managed via ident authentication. The only thing I have yet to figure out or understand is how to login to PostgreSQL as my user account but not to any specific database. I understand that when I am logged in

Re: [GENERAL] Post Install / Secure PostgreSQL

On 15/09/2010 12:50 AM, Carlos Mennens wrote: On Mon, Sep 13, 2010 at 9:58 PM, Craig Ringer wrote: craig$ sudo -u postgres psql postgres=> CREATE USER craig WITH PASSWORD 'somepassword' CREATEDB CREATEROLE; postgres=> CREATE DATABASE craig WITH OWNER craig; postgres=> \q So I s

Re: [GENERAL] Post Install / Secure PostgreSQL

On Tue, Sep 14, 2010 at 1:52 PM, Richard Broersma > You'd want to use "ALTER USER" > > http://www.postgresql.org/docs/8.4/interactive/sql-alteruser.html > > So: > > ALTER USER carlos WITH ENCRYPTED PASSWORD 'password'; I find it strange when I am logged in as super user 'postgres' and type the ex

Re: [GENERAL] Post Install / Secure PostgreSQL

On Tue, Sep 14, 2010 at 9:50 AM, Carlos Mennens wrote: > Secondly I am unable to find any information in the docs that show me > how to set just the user password for 'carlos'. In MySQL I would use: > > SET PASSWORD FOR 'carlos'@'localhost' = PASSWORD('newpass'); You'd want to use "ALTER USER"

Re: [GENERAL] Post Install / Secure PostgreSQL

On September 14, 2010 09:50:30 am Carlos Mennens wrote: > Obviously there appears to be a specific password for both accounts > which I think are completely seperate from the Linux shell passwords, > right? PostgreSQL has internal passwords for roles which can be set with "alter role" or while cr

Re: [GENERAL] Post Install / Secure PostgreSQL

On Mon, Sep 13, 2010 at 9:58 PM, Craig Ringer wrote: > craig$ sudo -u postgres psql > postgres=> CREATE USER craig WITH PASSWORD 'somepassword' >           CREATEDB CREATEROLE; > postgres=> CREATE DATABASE craig WITH OWNER craig; > postgres=> \q So I set a Linux shell password on my newly auto cr

Re: [GENERAL] Post Install / Secure PostgreSQL

On 14/09/2010 1:57 AM, Tom Lane wrote: I'd suggest creating "carlos" as either a plain user or a CREATEROLE user depending on whether you think you're likely to be adding/deleting plain users regularly. I'd second that. When I install a new instance of PostgreSQL, I usually set up a "craig" u

Re: [GENERAL] Post Install / Secure PostgreSQL

On Mon, Sep 13, 2010 at 12:24 PM, Carlos Mennens wrote: > On Mon, Sep 13, 2010 at 1:57 PM, Tom Lane wrote: > I also noticed that I created a database called 'ide' in PostgreSQL as > the 'postgres' super user and I am trying to change the owner of the > database to me and when I run the following

Re: [GENERAL] Post Install / Secure PostgreSQL

On Mon, Sep 13, 2010 at 1:57 PM, Tom Lane wrote: > It's definitely a good idea not to use a superuser account when you > don't have to; just like you don't use Unix root unless you have to. > You should do your day-to-day database hacking in an ordinary > unprivileged account. When I am logged in

Re: [GENERAL] Post Install / Secure PostgreSQL

Carlos Mennens writes: > In MySQL, it was recommended that you create a power user account > rather than manage the database with the 'root' account. Is this also > the same thing for PostgreSQL? I know you guys told me that there is > no 'root' account but there is a 'postgres' account which app

Re: [GENERAL] Post Install / Secure PostgreSQL

Thanks for all the assistance and clarification with my new install of PostgreSQL. I am able to switch users to 'postgres' and verify the default home directory for 'postgres' shell user: [r...@db1 ~]# su - postgres [postg...@db1 ~]$ pwd /var/lib/postgres I am also now able from the documentatio

Re: [GENERAL] Post Install / Secure PostgreSQL

On Fri, Sep 10, 2010 at 01:23:39PM -0700, bjjjrn lundin wrote: > I usually do like this on a new box > > sudo su - > su - postgres > createuser bnl > exit > exit It would be somewhat easier to use sudo's "-u" switch, the following should do the same as the above: sudo -u postgres createuser "$

Re: [GENERAL] Post Install / Secure PostgreSQL

On 09/11/2010 01:39 AM, Arjen Nienhuis wrote: su - postgres psql -l If you didn't set a password for the postgres user it's actually: sudo su - postgres Better written, and less prone to being broken by odd shell setups, as: sudo -u postgres psql -- Craig Ringer -- Sent via pgsq

Re: [GENERAL] Post Install / Secure PostgreSQL

Carlos Mennens wrote on 10.09.2010 17:53: On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma wrote: I don't believe there is a script like this. However, I would say that out of the box, PostgreSQL is so secure that some people cannot figure out how to log in. :) I agree and I am just now l

Re: [GENERAL] Post Install / Secure PostgreSQL

>I can't seem to find out how > to login to the database. I am using 'psql -U root' however during my > installation there may have been a default password used which I am > not aware of. I need to read the docs and see how to login to the > database. I usually do like this on a new box sudo su -

Re: [GENERAL] Post Install / Secure PostgreSQL

>    su - postgres >    psql -l If you didn't set a password for the postgres user it's actually: sudo su - postgres -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Post Install / Secure PostgreSQL

On Fri, Sep 10, 2010 at 11:53:12AM -0400, Carlos Mennens wrote: > On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma > wrote: > > I don't believe there is a script like this.  However, I would say > > that out of the box, PostgreSQL is so secure that some people > > cannot figure out how to log in

Re: [GENERAL] Post Install / Secure PostgreSQL

On Fri, Sep 10, 2010 at 11:33 AM, Richard Broersma wrote: > I don't believe there is a script like this.  However, I would say > that out of the box, PostgreSQL is so secure that some people cannot > figure out how to log in. :) I agree and I am just now learning this. I can't seem to find out ho

Re: [GENERAL] Post Install / Secure PostgreSQL

Carlos Mennens writes: > I am brand new to PostgreSQL and coming from MySQL. My question is > does anyone know after I install PostgreSQL on my Linux server, is > there a script that secures the database like MySQL offers in most > Linux distributions? I think the script for MySQL is > "/usr/bin/m

Re: [GENERAL] Post Install / Secure PostgreSQL

On Fri, Sep 10, 2010 at 8:12 AM, Carlos Mennens wrote: > Do you guys know if this exist for PostgreSQL and or do you have any > suggestions for a fresh installation of PostgreSQL on Linux? I don't believe there is a script like this. However, I would say that out of the box, PostgreSQL is so se

[GENERAL] Post Install / Secure PostgreSQL

I am brand new to PostgreSQL and coming from MySQL. My question is does anyone know after I install PostgreSQL on my Linux server, is there a script that secures the database like MySQL offers in most Linux distributions? I think the script for MySQL is "/usr/bin/mysql_secure_installation". I check

Re: [GENERAL] Post to another db using pl/pgsql

On Nov 12, 2008, at 8:55 AM, Robert Fitzpatrick wrote: I've worked with pgsql for a while, but never needed to post from a database trigger to another db. Is this possible? And if so, can someone offer a pointer to the docs on how to refer to other db's in my script, etc? Look for dblink

Re: [GENERAL] Post to another db using pl/pgsql

On Wed, 2008-11-12 at 18:02 +0100, [EMAIL PROTECTED] wrote: > > I've worked with pgsql for a while, but never needed to post from a > > database trigger to another db. Is this possible? And if so, can someone > > offer a pointer to the docs on how to refer to other db's in my script, > > etc? > >

Re: [GENERAL] Post to another db using pl/pgsql

> I've worked with pgsql for a while, but never needed to post from a > database trigger to another db. Is this possible? And if so, can someone > offer a pointer to the docs on how to refer to other db's in my script, > etc? What do you mean by 'other db'? Does that mean other PostgreSQL database

Re: [GENERAL] Post to another db using pl/pgsql

> I've worked with pgsql for a while, but never needed to post from a > database trigger to another db. Is this possible? And if so, can someone > offer a pointer to the docs on how to refer to other db's in my script, > etc? What do you mean by 'other db'? Does that mean other PostgreSQL database

[GENERAL] Post to another db using pl/pgsql

I've worked with pgsql for a while, but never needed to post from a database trigger to another db. Is this possible? And if so, can someone offer a pointer to the docs on how to refer to other db's in my script, etc? -- Robert -- Sent via pgsql-general mailing list (pgsql-general@postgresql.o

Re: [GENERAL] Post-installation questions

On Sat, Apr 12, 2008 at 03:05:41PM +, william wayne wrote: > This is a newbie question as I have not used the product before. After > installation of PG 8.2 I noticed that I have 2 servers: postgresql > database server 8.2 (localhost:5432) and another one differing only > in the name (the secon

[GENERAL] Post-installation questions

Hello: This is a newbie question as I have not used the product before. After installation of PG 8.2 I noticed that I have 2 servers: postgresql database server 8.2 (localhost:5432) and another one differing only in the name (the second one is 8.3). The problem is that I did not request the 8

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

On Wed, 28 Feb 2007, Tom Lane wrote: Stop the postmaster, remove the bogus socket file by hand, start the postmaster. Tom, That did it. I imagine that if you check the postmaster log you will notice a bleat near the beginning about failing to open the socket file (because of the pre-exist

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

Rich Shepard <[EMAIL PROTECTED]> writes: >Is there a method other than a reboot to remedy this? Stop the postmaster, remove the bogus socket file by hand, start the postmaster. I imagine that if you check the postmaster log you will notice a bleat near the beginning about failing to open the

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible -- FIXED

On Wed, 28 Feb 2007, Alan Hodgson wrote: Something happened to your /tmp directory after PostgreSQL started up. Alan, Seems so, doesn't it? Stop the postmaster, clean out the socket in /tmp, and restart the postmaster, and it will likely fix it up. Then you can investigate your boot proc

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

On Wednesday 28 February 2007 08:12, Rich Shepard <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] ~]$ psql -h localhost -U postgres aesi > Welcome to psql 8.1.4, the PostgreSQL interactive terminal. > > Type: \copyright for distribution terms > \h for help with SQL commands > \? f

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

On Wed, 28 Feb 2007, Tom Lane wrote: The socket file should surely not be owned by root ... there's something pretty weird there. How did you start the postmaster? Tom, The startup script, /etc/rc.d/rc.postgresql is run when the system boots. The result is, 16648 pts/1S 0:00 /usr

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

On Wed, 28 Feb 2007, Joshua D. Drake wrote: psql -h localhost -U postgres databasename Joshua, Well, something's wrong: [EMAIL PROTECTED] ~]$ psql -h localhost -U postgres aesi Welcome to psql 8.1.4, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

Rich Shepard <[EMAIL PROTECTED]> writes: >The postmaster is running: > 9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data > and the socket is present: > srwxrwxrwx 1 root root 0 2007-02-28 05:20 /tmp/.s.PGSQL.5432= The socket file should surely not be owned by root ... there'

Re: [GENERAL] Post-Reboot Issue: Postmaster Not Accessible

Rich Shepard wrote: > After having to reboot my server/workstation this morning, I've a > problem with > postgresql; one I've never before encountered. > > The postmaster is running: > > 9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data > > and the socket is present: > >

[GENERAL] Post-Reboot Issue: Postmaster Not Accessible

After having to reboot my server/workstation this morning, I've a problem with postgresql; one I've never before encountered. The postmaster is running: 9959 pts/1S 0:00 /usr/bin/postmaster -D /var/lib/pgsql/data and the socket is present: srwxrwxrwx 1 root root 0 2007-02-28 05:20

Re: [GENERAL] post

Well, go ahead... On Tuesday 13 December 2005 10:41 am, Huub Fleuren saith: > i would like to make a post > > -- > -- > Geodan IT b.v. > Buitenhaven 27-A > 5211 TP 's-Hertogenbosch (NL) > - > Tel: +31 (0)73 - 692 5151 > Fax:

[GENERAL] post

i would like to make a post -- -- Geodan IT b.v. Buitenhaven 27-A 5211 TP 's-Hertogenbosch (NL) - Tel: +31 (0)73 - 692 5151 Fax: +31 (0)73 - 692 5150 Mobiel: - Postadres / mailing address

Re: [GENERAL] Post gresql commands

On Thu, Feb 19, 2004 at 20:39:13 +0300, anwar <[EMAIL PROTECTED]> wrote: > How can i get a list of database in postgresql psql -l ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [GENERAL] Post gresql commands

anwar schrieb: How can i get a list of database in postgresql anwar psql -l for details see: http://www.postgresql.org/docs/7.4/static/app-psql.html ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[GENERAL] Post gresql commands

How can i get a list of database in postgresql anwar ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the