Re: [Postgres-xc-general] [SOLVED] Re: [GENERAL] cloning postgres-xc

2013-02-12 Thread Koichi Suzuki
Appreciate for very nice and interesting topics. -- Koichi Suzuki 2013/2/13 Zenaan Harkness : > [SOLVED] > > On 2/13/13, Michael Paquier wrote: >> On Wed, Feb 13, 2013 at 1:28 PM, Zenaan Harkness wrote: >> >>> On 2/13/13, Zenaan Harkness wrote: >>> > # this resulted in only 8.6MiB down

Re: [Postgres-xc-general] [GENERAL] cloning postgres-xc

2013-02-12 Thread Michael Paquier
On Wed, Feb 13, 2013 at 1:28 PM, Zenaan Harkness wrote: > On 2/13/13, Zenaan Harkness wrote: > > # this resulted in only 8.6MiB download just now, > > # on an up-to-date pg.git repo. > This quantity of data looks correct, half of it being due to the data in doc-xc/. $ git remote set-branches --

[SOLVED] Re: [Postgres-xc-general] [GENERAL] cloning postgres-xc

2013-02-12 Thread Zenaan Harkness
[SOLVED] On 2/13/13, Michael Paquier wrote: > On Wed, Feb 13, 2013 at 1:28 PM, Zenaan Harkness wrote: > >> On 2/13/13, Zenaan Harkness wrote: >> > # this resulted in only 8.6MiB download just now, >> > # on an up-to-date pg.git repo. > > This quantity of data looks correct, half of it being due

{solved} Re: postgres fails to start

2011-07-13 Thread kuLa
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/07/11 12:36, kuLa wrote: > Hi all, > I'm having crazy problem which I can't solve. > Basically I have 12 sets (master + slave) of postgres on Lenny. Master > is shipping WAL files into slaves where they are applied. Easy pesy > works perfectly, e

Re: postgres fails to start

2011-07-13 Thread Jude DaShiell
If each slave is on its own drive, the problem slave may be on a corrupted drive. If the corruption happens in the right place on that drive that would probably explain your difficulty. On Tue, 12 Jul 2011, kuLa wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Hi all, > I'm having

Re: Postgres server does not start.

2010-02-02 Thread Sthu Deus
Thank You for Your time and answer, debu...@acrasis.net: >On 2010-01-31 13:43, Sthu Deus wrote: >> 2010-01-31 13:31:03 GMT-7 LOG: could not bind IPv4 socket: Address already >> in use >> 2010-01-31 13:31:03 GMT-7 HINT: Is another postmaster already >> running on port 5432? If not, wait a few sec

Re: Postgres server does not start.

2010-01-31 Thread debuser
On 2010-01-31 13:43, Sthu Deus wrote: > 2010-01-31 13:31:03 GMT-7 LOG: could not bind IPv4 socket: Address already > in use > 2010-01-31 13:31:03 GMT-7 HINT: Is another postmaster already > running on port 5432? If not, wait a few seconds and retry. > 2010-01-31 13:31:03 GMT-7 WARNING: could not

Re: postgres install fails on sid

2007-10-15 Thread Andy Smith
Hi John, On Sun, Oct 07, 2007 at 06:05:42PM +, John Masters wrote: > I've chmod 666 /dev/null and now postgres installs OK. However I > hesitate to go further as this server is on a VPS. Could that be why the > perms were not set properly? I can think of no reason why anyone would provision a

Re: postgres install fails on sid

2007-10-07 Thread John Masters
On 19:14 Sun 07 Oct , Florian Kulzer wrote: > On Sun, Oct 07, 2007 at 16:35:44 +, John Masters wrote: > > On 16:04 Sun 07 Oct, Florian Kulzer wrote: > > > On Sun, Oct 07, 2007 at 13:49:11 +, John Masters wrote: > > > > I have posted this to the Postgres list also. > > > > > > > > Canno

Re: postgres install fails on sid

2007-10-07 Thread Florian Kulzer
On Sun, Oct 07, 2007 at 16:35:44 +, John Masters wrote: > On 16:04 Sun 07 Oct, Florian Kulzer wrote: > > On Sun, Oct 07, 2007 at 13:49:11 +, John Masters wrote: > > > I have posted this to the Postgres list also. > > > > > > Cannot get Postgres 8.2 working on Debian sid using the Debian pa

Re: postgres install fails on sid

2007-10-07 Thread John Masters
On 16:04 Sun 07 Oct , Florian Kulzer wrote: > On Sun, Oct 07, 2007 at 13:49:11 +, John Masters wrote: > > I have posted this to the Postgres list also. > > > > Cannot get Postgres 8.2 working on Debian sid using the Debian package. > > At the config stage I get a message telling me to run:

Re: postgres install fails on sid

2007-10-07 Thread Florian Kulzer
On Sun, Oct 07, 2007 at 13:49:11 +, John Masters wrote: > I have posted this to the Postgres list also. > > Cannot get Postgres 8.2 working on Debian sid using the Debian package. > At the config stage I get a message telling me to run:- > > pg_createcluster 8.2 main --start > > Doing th

Re: postgres default username/password

2007-01-27 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/27/07 12:24, Attila Horvath wrote: > Hi > > I downloaded pgAmin III so I can view my postgress DB remotely. > > What is the default username/password where installed apt packages are > managed? Huh? Do you mean the username and password of th

Re: Postgres question

2005-10-26 Thread Maurits van Rees
On Tue, Oct 25, 2005 at 06:25:52PM -0400, Roberto C. Sanchez wrote: > The 7.2 and 7,4 directories contain conf files, libraries and binaries > that appear like they belong to postgres. The stuff under preserve is > obviously a backup from when I upgraded from Woody to Sarge. My > question is, how

Re: postgres phpgroupware login woes

2004-08-26 Thread Oliver Elphick
for <[EMAIL PROTECTED]>; Thu, 26 Aug 2004 18:15:26 +0100 Subject: Re: postgres phpgroupware login woes From: Oliver Elphick <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Lance Hoffmeyer <[EMAIL PROTECTED]> In-Reply-To: <[EMAIL PROTECTED]> References: <[EMAIL PRO

Re: postgres phpgroupware login woes

2004-08-26 Thread Oliver Elphick
On Thu, 2004-08-26 at 05:30, Lance Hoffmeyer wrote: > Running SARGE. I have everything installed > and appears to be installed correctly. If > I login as user postgres I can login to > a database phpgroupware. If I am any other > user and I run command > > psql phpgroupware -U postgres -W >

Re: postgres ident error

2004-05-25 Thread Oliver Elphick
On Tue, 2004-05-25 at 02:36, Tom Allison wrote: > So the "tcpip_socket=yes" statement has nothing to do with TCP/IP > connection? While tcpip_sockets=no is the default from postgres, the > configuration file in Debian shows otherwise. tcpip_socket=yes makes the postmaster listen for TCP/IP conn

Re: postgres ident error

2004-05-24 Thread Tom Allison
J.H.M. Dassen (Ray) wrote: On Sun, May 23, 2004 at 14:46:34 -0400, Tom Allison wrote: J.H.M. Dassen (Ray) wrote: PostgreSQL doesn't care about /etc/passwd. The default client authentication settings care about what user is connecting to the database server through a UNIX socket. Gee I must have mi

Re: postgres ident error

2004-05-23 Thread J.H.M. Dassen (Ray)
On Sun, May 23, 2004 at 14:46:34 -0400, Tom Allison wrote: > J.H.M. Dassen (Ray) wrote: > >PostgreSQL doesn't care about /etc/passwd. The default client > >authentication settings care about what user is connecting to the > >database server through a UNIX socket. > Gee I must have missed something

Re: postgres ident error

2004-05-23 Thread Tom Allison
J.H.M. Dassen (Ray) wrote: On Sat, May 22, 2004 at 19:36:38 -0400, Tom Allison wrote: I created a user in psql but now I can't log in as that user. I get an error psql: FATAL: IDENT authentication failed for user "dbmail" This implies that I need to have all my users for pgsql listed in both the

Re: postgres ident error

2004-05-23 Thread J.H.M. Dassen (Ray)
On Sat, May 22, 2004 at 19:36:38 -0400, Tom Allison wrote: > I created a user in psql but now I can't log in as that user. > > I get an error > psql: FATAL: IDENT authentication failed for user "dbmail" > > This implies that I need to have all my users for pgsql listed in both > the /etc/passwd

Re: postgres installation question

2004-05-23 Thread Oliver Elphick
On Sat, 2004-05-22 at 22:19, Tom Allison wrote: > I'm doing a -testing installation of postgresql. > > I have the user postgres in the passwd file. > I don't know what the password is. > > I'm wondering: > > Should I know it? I can always su posgres from root, but I don't always > want to have

Re: Postgres

2004-01-17 Thread glenn
just for kicks - try "su - postgres" - seems to work for me Glenn On Sun, 2004-01-18 at 10:25, Christoph Bühring wrote: > Hi, > I´ve got following Problem: > > initdb: cannot be run as root > Please log in (using, e.g., "su") as the (unprivileged) user that will > own the server

Re: postgres do.maintenance question

2004-01-09 Thread Oliver Elphick
On Wed, 2004-01-07 at 23:21, Monique Y. Herman wrote: > How important is it to run the default-install do.maintenance cron job > if you're running autovacuum? Should I just get rid of it? > > Since my last upgrade of postgres on unstable, I've received the > following email several times a day: >

Re: postgres connects to server every 5 minutes

2004-01-06 Thread Alexander Wirz
Oliver Elphick <[EMAIL PROTECTED]> wrote: >> reason for this behaviour? > > pg_autovacuum (from postgresql-contrib) is started by > /etc/init.d/postgresql (if so configured by > /etc/postgresql/postmaster.conf). It is turned on by default. > > -- > Oliver Elphick[

Re: postgres connects to server every 5 minutes

2004-01-06 Thread Oliver Elphick
On Tue, 2004-01-06 at 18:16, outsider wrote: > Hi! > After an upgrade from postgres 7.3 to postgres 7.4 I see every 5 minutes > in the /var/syslog messages like > --- > connection: Host=[local] Port= > user=postgres > --- > postgres connects every 5 minutes to each database I have. What is the >

Re: postgres connects to server every 5 minutes

2004-01-06 Thread John M Flinchbaugh
On Tue, Jan 06, 2004 at 07:16:24PM +0100, outsider wrote: > After an upgrade from postgres 7.3 to postgres 7.4 I see every 5 minutes > in the /var/syslog messages like > --- > connection: Host=[local] Port= > user=postgres > --- > postgres connects every 5 minutes to each database I have. What is

Re: postgres date formatting? (SOLVED)

2003-12-23 Thread Paul Morgan
On Mon, 22 Dec 2003 16:04:05 -0700, Monique Y. Herman wrote: > > Thank you so much! This is exactly what I was looking for, and your > example made it very easy to understand. My pleasure. I'm not that good at much, but I'm fairly good with SQL stuff. -- paul Guy: "Would

Re: postgres date formatting? (SOLVED)

2003-12-22 Thread Monique Y. Herman
On Mon, 22 Dec 2003 at 21:30 GMT, Paul Morgan penned: > > Monique, you're using the to_date function the wrong way round, which is > not an uncommon mistake. > > to_date() converts a string to a date, *not* a date to a string. So your > working example works because to_date() is taking the strin

Re: postgres date formatting?

2003-12-22 Thread Monique Y. Herman
On Mon, 22 Dec 2003 at 22:28 GMT, Pablo Aguiar penned: > On Sun, 21 Dec 2003 20:34:28 -0700 "Monique Y. Herman" > <[EMAIL PROTECTED]> wrote: > >> Summary: attempting to use to_date on a table value results in a >> to_timestamp error. What am I doing wrong? > > You have to tell PostgreSQL the for

Re: postgres date formatting?

2003-12-22 Thread Paul Morgan
On Sun, 21 Dec 2003 20:34:28 -0700, Monique Y. Herman wrote: > I know this isn't the postgres user group, but if anyone has any > insight, I'd sure appreciate it. > > Summary: attempting to use to_date on a table value results in a > to_timestamp error. What am I doing wrong? > > I have a littl

Re: postgres date formatting?

2003-12-22 Thread Pablo Aguiar
On Sun, 21 Dec 2003 20:34:28 -0700 "Monique Y. Herman" <[EMAIL PROTECTED]> wrote: > Summary: attempting to use to_date on a table value results in a > to_timestamp error. What am I doing wrong? You have to tell PostgreSQL the format of the string date you are passing to to_timestamp (or to to_da

Re: Postgres

2003-10-05 Thread Oliver Elphick
On Sun, 2003-10-05 at 01:17, Dan Roscoe wrote: > Hello! > > I'm wondering if anyone has had any problems setting up phpbb2 > (http://phpbb2.com) with PostgreSQL on a woody box. > > I am consistently getting error messages along the lines of > > > Warning: Unable to connect to PostgreSQL server

Re: Postgres

2003-10-05 Thread J.H.M. Dassen (Ray)
On Sat, Oct 04, 2003 at 18:17:24 -0600, Dan Roscoe wrote: > Warning: Unable to connect to PostgreSQL server: FATAL 1: IDENT > authentication failed for user "dan" in /var/www/boards/db/postgres7.php > on line 79 > phpBB : Critical Error > > Could not connect to the database > > which would lead s

Re: postgres upgrade failed.....

2002-12-10 Thread Rob Weir
On Thu, Dec 05, 2002 at 05:26:33PM +0100, Bruno Boettcher wrote: > Hello > > i got used to the automatic postgres upgrade... and stopped making > myself dumps before upgrading... :( > > and now i am stuck.. the automatic upgrade failed, and i don't know > how to get this back... > > i tr

Re: postgres: No pg_hba.conf entry for host

2002-09-26 Thread Oliver Elphick
On Thu, 2002-09-26 at 08:51, Erik Steffl wrote: >I get the following error message when trying to connect to postgres > using tora: > > No pg_hba.conf entry for host... > >I think that the settings are ok since I can loging using psql: > > jojda:~> psql pokus -U erik -W This is using

Re: Postgres forms/reports tools?

2002-05-01 Thread Tom Cook
On 0, stan <[EMAIL PROTECTED]> wrote: > I'm going to set up some databases for various personal use (household > itmems, books, music, et all) using porgres for the db. > > This will be done on a woody machine. > > Cany anyone recomend ood tools for dat input forms & reports> I'm thinking > of

Re: postgres 7.1 -> 7.2 ... sigh

2002-04-21 Thread Oliver Elphick
On Mon, 2002-04-22 at 03:17, Andreas Goesele wrote: ... > You are now connected to database template1 as user postgres. > CREATE DATABASE "accounts" WITH TEMPLATE = template0 ENCODING = 'LATIN1'; > ERROR: CREATE DATABASE: database "accounts" already exists > You are now connected to database accou

Re: postgres 7.1 -> 7.2 ... sigh

2002-04-21 Thread Andreas Goesele
Jason Chambers <[EMAIL PROTECTED]> writes: > > CREATE USER "user" WITH SYSID 1 CREATEDB CREATEUSER; > > ERROR: CREATE USER: sysid 1 is already assigned > ^^^ > > Sysid 1 is probably assigned to the user postgres created by the > install. To get you

Re: postgres 7.1 -> 7.2 ... sigh

2002-04-20 Thread Jason Chambers
Andreas Goesele wrote: I had big problems going from 6.5 to 7.1 and now going from 7.1.3-7 again doesn't go smooth. (On an up do date woody.) The problem seems to be related to the fact that I call myself "user" (fanciful name, isn't it?), but shouldn't one be free to call the users as one likes

Re: postgres update database problem

2002-03-21 Thread Oliver Elphick
On Thu, 2002-03-21 at 04:54, Lance Hoffmeyer wrote: > I tried to upgrade php4-pgsql and ended up having to upgrade the database. > I ended the postgresql-dump early and all I have is a saved.data directory > and a db.out file. How do I recreate my database from one of these? If the db.out is righ

Re: postgres 7.1 (woody) - how to stop debugging

2002-03-01 Thread Oliver Elphick
On Thu, 2002-02-28 at 21:38, Andreas Goesele wrote: > I also have debug_level = 0 in postgresql.conf believing that this > would stop all debugging massages, but this is not the case. My > console gets flooded by messages of the type: DEBUG: ... > > Is there any way I can effectively st

Re: postgres 7.1 - too much logging

2002-02-18 Thread Martin Wuertele
Hi Andreas! On Mon, 18 Feb 2002, Andreas Goesele wrote: > thanks to help from this list I now finally have successfully upgraded > to postgresql 7.1. > > But now my syslog gets to much logging from postgres. In > postgresql.conf I have: > > debug_level = 0 > log_connections = on if only localh

RE: postgres 7.1 - too much logging

2002-02-18 Thread Brooks R. Robinson
| But now my syslog gets to much logging from postgres. In | postgresql.conf I have: | | debug_level = 0 | log_connections = on | log_pid = on | log_timestamp = on | syslog = 2 | # if syslog is 0, turn silent_mode off! | silent_mode = off | syslog_facility = LOCAL0 | trace_notify = off Try these

Re: postgres upgrade for dummies? [solved]

2002-02-17 Thread Andreas Goesele
Andreas Goesele <[EMAIL PROTECTED]> writes: > "J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > > > Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new > > authentication method "peer" which 6.5 doesn't understand and which 7.1's > > default configuration employs IIRC. > > Thi

Re: postgres upgrade for dummies?

2002-02-17 Thread Andreas Goesele
"J.H.M. Dassen (Ray)" <[EMAIL PROTECTED]> writes: > Switch back to the pg_hba.conf file you used with 6.5. 7.1 has a new > authentication method "peer" which 6.5 doesn't understand and which 7.1's > default configuration employs IIRC. This helped. Thanks. But now I have a new problem: The encodin

Re: postgres upgrade for dummies?

2002-02-17 Thread Oliver Elphick
On Sun, 2002-02-17 at 14:20, J.H.M. Dassen (Ray) wrote: > On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote: > > So I did read README.Debian.migration.gz and then run postgresql-dump > > with the options in the README. This is what I got: > > > > Stopping and restarting the postmaster

Re: postgres upgrade for dummies?

2002-02-17 Thread J.H.M. Dassen \(Ray\)
On Sun, Feb 17, 2002 at 01:38:52 +0100, Andreas Goesele wrote: > I now did a new try, again without any success. The automatic > upgrading process first looks promising but than ends with the > following error message: > You are now connected to database template1 as user user. > create database u

Re: Postgres Version in 2.2r3

2001-09-19 Thread Oliver Elphick
bob parker wrote: >Could anyone let me know what version of postgres >comes with 2.2r3 please. >I've tried the obvious postgres -v, psql -v to no >avail. SELECT version(); potato (2.2) contains PostgreSQL 6.5.3 -- Oliver Elphick[EMAIL PROTECTED] Isle of W

Re: Postgres Version in 2.2r3

2001-09-19 Thread J.H.M. Dassen \(Ray\)
On Wed, Sep 19, 2001 at 00:16:38 -0700, bob parker wrote: > I've tried the obvious postgres -v, psql -v to no avail. dpkg -l 'postgres*' will inform you that it is 6.5.3. A version of 7.1 built for potato is available from http://people.debian.org/~elphick/postgresql/potato.html HTH, Ray -- POPU

Re: postgres user

2001-04-25 Thread Oliver Elphick
Blake Barnett wrote: >Call me crazy, but I can't seem to get into the database anymore. The >postgres user didn't have a password before and it won't accept a blank >password anymore. The postgres user was the only user and so there's no way >to get in to modify him. Am I just being dens

Re: Postgres do.maintenance

2001-04-11 Thread Oliver Elphick
[EMAIL PROTECTED] wrote: >Hello, > >I've just installed postgresql 7.0 from unstable. Everything is ok, >except for the do.maintenance script. Right now it's running for 392 >minutes eating up 70% CPU constantly, though I have only 1 >postgres database and no data in it. > >This

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Christoph Simon
On Mon, 4 Dec 2000 06:10:55 -0800 (PST) Chris Mayes <[EMAIL PROTECTED]> wrote: > I've finally managed to connect. It looks like psql is acting odd > (then again, maybe this is the default behavior... I am normally a > MySQL/Oracle user). Basically, psql requires that I explicitly supply > a host

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Oliver Elphick
Chris Mayes wrote: >I've finally managed to connect. It looks like psql is acting odd >(then again, maybe this is the default behavior... I am normally a >MySQL/Oracle user). Basically, psql requires that I explicitly supply >a hostname. So, even though psql complains about being refused

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Chris Mayes
I've finally managed to connect. It looks like psql is acting odd (then again, maybe this is the default behavior... I am normally a MySQL/Oracle user). Basically, psql requires that I explicitly supply a hostname. So, even though psql complains about being refused on port 5432 on localhost, I c

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Christoph Simon
On Mon, 4 Dec 2000 04:51:50 -0800 (PST) Chris Mayes <[EMAIL PROTECTED]> wrote: > > Set > > PGALLOWTCPIP=yes > > in /etc/postgresql/postmaster.init and restart postgres. > > > Well, nmap (and lsof) reports that the postgres port is open and > listening, but I still get: > > > psql:

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Chris Mayes
--- Christoph Simon <[EMAIL PROTECTED]> wrote: > On Sun, 3 Dec 2000 21:05:32 -0800 (PST) > Chris Mayes <[EMAIL PROTECTED]> wrote: > > > Hello, everyone. > > > > So, here's the problem: In a nutshell, Postgres doesn't seem to be > > listening on port 5432 (which is where everything seems to be

Re: Postgres Port Problem (and other port issues)

2000-12-04 Thread Christoph Simon
On Sun, 3 Dec 2000 21:05:32 -0800 (PST) Chris Mayes <[EMAIL PROTECTED]> wrote: > Hello, everyone. > > So, here's the problem: In a nutshell, Postgres doesn't seem to be > listening on port 5432 (which is where everything seems to be looking > for it). Nmap confirms this, plus none of the stuf

Re: postgres database framework disappeared: Solved

2000-06-04 Thread Miguel Wooding SF Ten.Union
Johann Spies <[EMAIL PROTECTED]> writes: > On Sat, Jun 03, 2000 at 12:05:45AM +0100, Oliver Elphick wrote: > > Johann Spies wrote: > > >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > > >In /etc/passwd the line was > > >postgres:x:31:32:postgres:/var/lib/postgres:/bin/sh >

Re: postgres database framework disappeared: Solved

2000-06-03 Thread Johann Spies
On Sat, Jun 03, 2000 at 12:05:45AM +0100, Oliver Elphick wrote: > Johann Spies wrote: > >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > > [snip] > >I found the culprit but still does not know how it happened: > > > >In /etc/passwd the line was > >postgres:x:31:32:pos

Re: postgres database framework disappeared: Solved

2000-06-02 Thread Oliver Elphick
Johann Spies wrote: >On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > >> I don't know how this happened. Suddenly postgres's postmaster is not >> running and trying to make it run results in the following error >> message: >> >> There is no PostgreSQL database framewo

Re: postgres database framework disappeared

2000-06-02 Thread Oliver Elphick
Johann Spies wrote: >Postgresql 6.5.3 on a mixed slink/potato system. > >I don't know how this happened. Suddenly postgres's postmaster is not >running and trying to make it run results in the following error >message: > >There is no PostgreSQL database framework in /var/postgres/dat

Re: postgres database framework disappeared: Solved

2000-06-02 Thread Johann Spies
On Fri, Jun 02, 2000 at 11:03:23PM +0200, Johann Spies wrote: > I don't know how this happened. Suddenly postgres's postmaster is not > running and trying to make it run results in the following error > message: > > There is no PostgreSQL database framework in /var/postgres/data. > Run initdb as

Re: postgres and php problem in slink

1999-11-13 Thread Oliver Elphick
Francesco Tapparo wrote: >I'm having some problems with php3, postgresql and php3-pgsql. When I >connect from an html page to my postgres server, I receive an error because >www-data is not a postgres user. In my pre-2.2 system I simply did >"createuser www.data", but if I try to do that in

Re: postgres

1999-08-26 Thread John Pearson
On Thu, Aug 26, 1999 at 11:55:14AM +0100, [EMAIL PROTECTED] wrote > Hallo all, > I've just installed the postgres stuff ok, but I thought I'd check out > a thought before I upset something. > I understand that user 'postgres' is the dba for postgres. It is user > postgres who adds and deletes

Re: postgres install error from apt

1999-07-19 Thread Oliver Elphick
Pollywog wrote: > >On 19-Jul-99 Oliver Elphick wrote: >> >> There was a filename clash between libpgsql2 and a previous release of >> postgresql. You will probably find that libpgsql2 is not properly >> installed. This was because the psql executable was moved between the two >> p

Re: postgres install error from apt

1999-07-19 Thread Doug Thistlethwaite
I was able to get postgresql 6.5-3 working running through the install twice as Oliver describes. Once it was complete psql worked as it did before. Doug Oliver Elphick wrote: > Pollywog wrote: > > > > > >Does anyone know what the problem might be? > > > > > >running dpkg --pending

Re: postgres install error from apt

1999-07-19 Thread Pollywog
On 19-Jul-99 Oliver Elphick wrote: > > There was a filename clash between libpgsql2 and a previous release of > postgresql. You will probably find that libpgsql2 is not properly > installed. This was because the psql executable was moved between the two > packages and I seem to have messed up

Re: postgres install error from apt

1999-07-19 Thread Oliver Elphick
Pollywog wrote: > > >Does anyone know what the problem might be? > > >running dpkg --pending --configure >... >Setting up postgresql-pl (6.5-3) ... >Enabling the PL procedural language in all PostgreSQL databases... >Could not execv /usr/lib/postgresql/bin/psql >Cannot select

Re: postgres install error from apt

1999-07-19 Thread egm2
Is the postmaster running? Can you use psql to connect to a database, say template1? If those work, I would think the script will work. I just upgraded the same thing and it worked fine. Did you just change to the 6.5 series postgres? If so, you'll have to run pgdump on your old databases before yo

Re: Postgres and Foreign keys...

1999-01-14 Thread Oliver Elphick
Amanda Shuler wrote: >According to the postgres mailing list, postgres does not support foriegn >keys inherently. Apparently there is a little program that is included >in the contrib directory underneath the PostgreSQL source tree that will >fix this. It is called "refint". I can't seem

Re: Postgres and php3 don't like each other

1998-12-23 Thread Frank Barknecht
Shaleh hat gesagt: // Shaleh wrote: > > On 21-Dec-98 Frank Barknecht wrote: > > I am playing around with Postgresql and php3 and I cannot make a database > > connection this way. The most simple script fails: > > > > > $database = pg_Connect ("", "", "", "", "template"); > > ?> > > > > Pass

RE: Postgres and php3 don't like each other

1998-12-21 Thread Shaleh
On 21-Dec-98 Frank Barknecht wrote: > Hi all, > I am playing around with Postgresql and php3 and I cannot make a database > connection this way. The most simple script fails: > > $database = pg_Connect ("", "", "", "", "template"); > ?> > Pass user and password in the pg_connect function. Lo

Re: postgres and php => error?

1998-11-02 Thread Shaleh
> > Not regarding the actual errors in the commandline, I'd like to notice that > postgresql doesn't like "www-data" as a user. It's the dash causing > problems. > > Try using another username when calling the database system. Actually it turns out I was using the wrong syntax in pg_connect. I

Re: postgres and php => error?

1998-11-02 Thread Remco van de Meent
On Fri, Oct 30, 1998 at 01:24:03PM -0500, Shaleh wrote: : The following is from my postgres log (log level set to three) : : usr/lib/postgresql/bin/postmaster: BackendStartup: pid 353 user www-data db wea : ther socket 5 : /usr/lib/postgresql/bin/postmaster child[0]: execv(/usr/lib/postgre

Re: postgres intallation failed

1998-06-29 Thread Jeff Noxon
On Mon, Jun 29, 1998 at 06:29:17AM +0200, Oliver Elphick wrote: > The bug is not in base-passwd but in postgresql. I used adduser to create > the account if it did't exist, but I had not noticed that `adduser --system' > assigns /bin/false as the shell. I have changed postgresql-6.3.2-11 > to use

Re: postgres intallation failed

1998-06-29 Thread Oliver Elphick
Jeff Noxon wrote: >On Sat, Jun 27, 1998 at 11:14:19AM +0200, Networking Wizard wrote: >> After Shared PostgreSQL library intsallation (libpgsql 6.3.2-8) >> i've been trying to inttall postgresql (6.3.2-8) severl times, >> but i did not succeed; dpkg terminates because of unspecified errors.

Re: postgres intallation failed

1998-06-29 Thread Jeff Noxon
On Sat, Jun 27, 1998 at 11:14:19AM +0200, Networking Wizard wrote: > After Shared PostgreSQL library intsallation (libpgsql 6.3.2-8) > i've been trying to inttall postgresql (6.3.2-8) severl times, > but i did not succeed; dpkg terminates because of unspecified errors. > Here is the log: > > > Unp

Re: postgres intallation failed

1998-06-28 Thread Oliver Elphick
Networking Wizard wrote: ... >It seemed a write-permission denial in /var/postgres sub-tree. Therefore >i switched back to root and changed the owner of /var/postgres: > >%% chown -R postgres.postgres /var/postgres I think I'll add this to the postinst script > >This time post

Re: postgres intallation failed

1998-06-28 Thread Networking Wizard
On Jun 27 1998 , Oliver Elphick wrote: > To find out what is going wrong with initdb: > Edit /usr/lib/postgresql/bin/initdb and add the line `set +x' after the > first line. Then become root and run the initialisation command (this > is all one line): > su - postgres -c "PATH=$PATH:/usr/lib/post

Re: postgres intallation failed

1998-06-27 Thread Oliver Elphick
Networking Wizard wrote: >After Shared PostgreSQL library intsallation (libpgsql 6.3.2-8) >i've been trying to inttall postgresql (6.3.2-8) severl times, >but i did not succeed; dpkg terminates because of unspecified errors. >Here is the log: > >> Unpacking replacement postgresql ...

Re: Postgres, php question

1998-06-25 Thread Gergely Madarasz
On Thu, 25 Jun 1998, Hamish Moffatt wrote: > On Wed, Jun 24, 1998 at 07:51:19AM -0400, Paul McDermott wrote: > > hello my debian user friends, I've installed Postgres.deb, php3.deb, > > apache.deb and www-pgsql from the slink area. I've done the postgres > > tutorial and it was great. Now i want

Re: Postgres, php question

1998-06-25 Thread Jeff Noxon
On Thu, Jun 25, 1998 at 12:27:56PM +1000, Hamish Moffatt wrote: > On Wed, Jun 24, 1998 at 07:51:19AM -0400, Paul McDermott wrote: > > hello my debian user friends, I've installed Postgres.deb, php3.deb, > > apache.deb and www-pgsql from the slink area. I've done the postgres > > tutorial and it wa

Re: Postgres, php question

1998-06-25 Thread Hamish Moffatt
On Wed, Jun 24, 1998 at 07:51:19AM -0400, Paul McDermott wrote: > hello my debian user friends, I've installed Postgres.deb, php3.deb, > apache.deb and www-pgsql from the slink area. I've done the postgres > tutorial and it was great. Now i want to start on makeing a web interface > for a databas

Re: Postgres, php question

1998-06-24 Thread Egon Schmid
On http://ca.php.net/news.php3 there are links to some good postgres/mysql oriented articles. -Egon PS: your email adress seems not valid On Wed, 24 Jun 1998, Paul McDermott wrote: > hello my debian user friends, I've installed Postgres.deb, php3.deb, > apache.deb and www-pgsql from the slink

Re: Postgres, php question

1998-06-24 Thread Miquel van Smoorenburg
In article <[EMAIL PROTECTED]>, Paul McDermott <[EMAIL PROTECTED]> wrote: >Is there a tutorial for the php3 program? See http://www.php.net/ Mike. -- Miquel van Smoorenburg | Our vision is to speed up time, [EMAIL PROTECTED] | eventually eliminating it. -- To UNSUBSCRIBE, email to [E

Re: [postgres] libpgperl: Pg.so: undefined symbol: PQconnectdb

1998-01-05 Thread Oliver Elphick
grin wrote: >I tried to use libpg_perl the first time, installed libpgperl, libpgsql, >postgresql-dev. > >When tried to run the test.pl, I got the following error message: >== >perl: error in loading shared libraries >/usr/lib/perl5/i386-linux/5.004/auto/Pg/Pg.so: undefine

Re: postgres-doc package

1997-12-03 Thread Daniel Martin
On Wed, 3 Dec 1997, Paul wrote: > Hi everybody, I have a very stupid question about the postgres95-doc > package. I can't find it. I mean it is installed and the only thing I > can find is the copyright notice. Where is it? What happen to it? This > package has a tutorial in it i think. Oh w

Re: Postgres What do you think

1997-12-03 Thread Oliver Elphick
Iztok Umek wrote: >Now I am downloading PostgreSQL 6.2.1 and will install it, hope old >programs are still compatible with it. I'm its maintainer. Please let me know how you get on and tell me of any problems. (Incidentally, I should be uploading a new version tonight with some fixes to pack

Re: Postgres What do you think

1997-12-02 Thread Ean Schuessler
I have been having a lot of fun with Java Servlets, JDBC and Postgres. Check out the java/apache stuff. On Tue, Dec 02, 1997 at 11:09:33PM +0100, Iztok Umek wrote: > Othervise... anyone knows good tool for www-postgres conectivity? --

Re: Postgres What do you think

1997-12-02 Thread Remco van de Meent
On Tue, 2 Dec 1997, Iztok Umek wrote: : Othervise... anyone knows good tool for www-postgres conectivity? I'm using PostgreSQL 6.2.1 and Apache WWW-server together, using the PHP/FI module. Works great! Mail me if you want some examples :) bye, Remco -- TO UNSUBSCRIBE FROM THIS MAILING LIST

Re: Postgres What do you think

1997-12-02 Thread Iztok Umek
On Tue, 2 Dec 1997, Paul wrote: > Hi everybody, I wanted to say thanks for all your help with samba. I have > been investigating in a database package. I was wondering if anybody uses > postgres95. I would like to have some feedback about this package. Any > problems, failures, sucesses or any

Re: Postgres What do you think

1997-12-02 Thread Andrew Akins
I would also like to know what people think of this. I've installed it, and it appears to be working, but I have yet to really get my hands dirty. -- ++ | Andrew Akins | | Hom

Re: Postgres

1997-10-17 Thread Oliver Elphick
Mario Jorge Nunes Filipe wrote: >Once again I'm here to talk about Postgres. > >It was suggested previously that a new package to exist should be >created using libc6. But (and correct me if i'm wrong) libc6 will only >be final with hamm, so it might make some sense to create a package

Re: postgres can't find libbsd.so.1.0.0 - where / how

1997-06-02 Thread sasharma
OK, I went and searched each of the archives for the last 9 months, starting last Nov. and in the May (april? - near the end of the search, anyway - natch)archives I found the answer, I need to download 6.0 from the postgres site and compile. Is there a cleaner way? should I place the entire b