Re: Debian Jessie Postgres 9.4 connection problem

2016-11-30 Thread Johann Spies
Try pg_lsclusters to see which postgresql servers are running and listening on which ports. Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)

Debian Jessie Postgres 9.4 connection problem

2016-11-30 Thread Ramon Hofer
Hi all I am trying to setup a postgresql 9.4 database on Debian Jessie. It worked well on testing with postgresql 9.6 from the repos and then I already could connect with $ sudo -u postgres psql I would like to use Jessie but when I try the same on stable with postgresql 9.4, this is what I get

Re: install postgres 8.4

2016-11-18 Thread Greg Wooledge
On Fri, Nov 18, 2016 at 01:42:24PM +0100, Robert Bude wrote: > but how i can install squeeze and are the packages in aktuell squeeze > mirrors ? and were to get squeeze mirror ? ;) https://wiki.debian.org/DebianSqueeze Squeeze is archived (no longer supported, even under "LTS"), so follow the in

install postgres 8.4

2016-11-18 Thread Robert Bude
Hi, we want to install a postgres 8.4 server but can not find via apt-get in wheezy or jessie the packages. How i can install a postgres 8.4 server with minimal effort ? i do not want a detailed instruction only the short track ;) eg.: install squeeze, install lts repo , and then you have

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

2013-02-12 Thread Koichi Suzuki
; fatal: No such remote 'master' >> >> I am not a GIT specialist, but in order to get all the branches, do only >> that: >> git remote add -f pgxc git:// >> postgres-xc.git.sourceforge.net/gitroot/postgres-xc/postgres-xc >> >> You will be able t

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

2013-02-12 Thread Michael Paquier
emote set-branches --add master pgxc/master > fatal: No such remote 'master' > I am not a GIT specialist, but in order to get all the branches, do only that: git remote add -f pgxc git:// postgres-xc.git.sourceforge.net/gitroot/postgres-xc/postgres-xc You will be able to see all

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

2013-02-12 Thread Zenaan Harkness
data looks correct, half of it being due to the data in > doc-xc/. > > $ git remote set-branches --add master pgxc/master >> fatal: No such remote 'master' > > I am not a GIT specialist, but in order to get all the branches, do only > that: > git remote add -f pgxc

Re: [GENERAL] cloning postgres-xc

2013-02-12 Thread Zenaan Harkness
On 2/13/13, Zenaan Harkness wrote: > Here's what I just tried: > > cd postgresql.git/ > git remote add -f --tags -m master pgxc > git://postgres-xc.git.sourceforge.net/gitroot/postgres-xc/postgres-xc Please note, the above two lines should be one, forgot to manually for

Re: [GENERAL] cloning postgres-xc

2013-02-12 Thread Zenaan Harkness
Here's what I just tried: cd postgresql.git/ git remote add -f --tags -m master pgxc git://postgres-xc.git.sourceforge.net/gitroot/postgres-xc/postgres-xc # this resulted in only 8.6MiB download just now, # on an up-to-date pg.git repo. #view results: git remote -v git branch -a In my

Re: [GENERAL] cloning postgres-xc

2013-02-12 Thread Zenaan Harkness
fyi.. -- Forwarded message -- From: Michael Paquier Date: Wed, 13 Feb 2013 12:59:54 +0900 On Tue, Feb 12, 2013 at 2:36 PM, Zenaan Harkness wrote: > Does somone know the object overlap likely between pg and pgxc > repositories? > > I ask because I could just git clone pgxc, or I

{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

Re: postgres fails to start

2011-07-13 Thread Jude DaShiell
i 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, except 1 set where I even can't bring up postgres on slave.

postgres fails to start

2011-07-12 Thread kuLa
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 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, except 1 set where I even can&

Re: removing postgres

2010-11-03 Thread Sthu Deus
Thank You for Your time and answer, Jochen: > Ok, so the installed package is broken. What message do you get when > you try to reinstall that package? Well. I have installed again: postgresql-client-common postgresql-common , did change ownership (user and group to postgres) of my clust

Re: removing postgres

2010-11-03 Thread Jochen Schulz
Sthu Deus: > Jochen: >> >> Why do you use dpkg for that? Have you tried apt-get or aptitude? I >> guess they will do what you want to achieve. >> >> J. > > I've tried that already. Please check this: > > The following packages will be REMOVED: > postgresql-8.3 [8.3.11-0lenny1] postgresql-cli

Re: removing postgres

2010-11-02 Thread Sthu Deus
Thank You for Your time and answer, Jochen: > Sthu Deus: > > > > I can not remove the following: > > > > $ sudo /usr/bin/dpkg -r postgresql-8.3 postgresql-client-8.3 > > Why do you use dpkg for that? Have you tried apt-get or aptitude? I > guess they will do what you want to achieve. > > J. I

Re: removing postgres

2010-11-02 Thread Sthu Deus
tually this is the very reason why I remove postgres - I need it, but it is of no worth to me as long as it does not work - it just takes my disc space. -- To UNSUBSCRIBE, email to debian-user-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@

Re: removing postgres

2010-11-02 Thread Jochen Schulz
Sthu Deus: > > I can not remove the following: > > $ sudo /usr/bin/dpkg -r postgresql-8.3 postgresql-client-8.3 Why do you use dpkg for that? Have you tried apt-get or aptitude? I guess they will do what you want to achieve. J. -- Americans have a better life. [Agree] [Disagree]

Re: removing postgres

2010-11-02 Thread Javier Barroso
On Tue, Nov 2, 2010 at 6:21 PM, Sthu Deus wrote: > Good day. > > I can not remove the following: > > $ sudo /usr/bin/dpkg -r postgresql-8.3 postgresql-client-8.3 > Removing postgresql-8.3 ... > /var/lib/dpkg/info/postgresql-8.3.prerm: line > 17: /usr/share/postgresql-common/maintscripts-functions:

removing postgres

2010-11-02 Thread Sthu Deus
Good day. I can not remove the following: $ sudo /usr/bin/dpkg -r postgresql-8.3 postgresql-client-8.3 Removing postgresql-8.3 ... /var/lib/dpkg/info/postgresql-8.3.prerm: line 17: /usr/share/postgresql-common/maintscripts-functions: No such file or directory dpkg: error processing postgresql-8.3

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

Postgres server does not start.

2010-01-30 Thread Sthu Deus
Good day. Please, help me to run my postgres DB. Here is problem description. I have 2 instances in /var/lib/postgresql/8.3: main mine When I start postgres server w/ command: /etc/init.d/postgresql-8.3 start I get: Starting PostgreSQL 8.3 database server: main mineThe PostgreSQL server

Re: apt-get upgrade... and now postgres 7.4 won't start!

2009-01-26 Thread Eugene V. Lyubimkin
will trillich wrote: > on debian 4.0, apt-get update && apt-get upgrade led to a problem > where postgres 7 won't start! apparently utility program > "pg_controldata" is supposed to generate some locale-info that's > parsed by perl script "pg_ctlclust

apt-get upgrade... and now postgres 7.4 won't start!

2009-01-25 Thread will trillich
on debian 4.0, apt-get update && apt-get upgrade led to a problem where postgres 7 won't start! apparently utility program "pg_controldata" is supposed to generate some locale-info that's parsed by perl script "pg_ctlcluster", and the two suddenly don&

Re: Another problem Postgresql: createdb: could not connect to database postgres: could not connect to server: No such file or directory

2008-04-12 Thread NN_il_Confusionario
On Sat, Apr 12, 2008 at 10:45:46AM +0530, Jaisen N.D. wrote: > I have another problem with postgresql 8.1. > initdb: directory "/var/lib/postgresql/data" exists but is not empty > If you want to create a new database system, either remove or empty > the directory "/var/lib/postgresql/data" or run i

Another problem Postgresql: createdb: could not connect to database postgres: could not connect to server: No such file or directory

2008-04-11 Thread Jaisen N.D.
I have another problem with postgresql 8.1. I have uninstalled the postgresql-8.3 and removed its configuration files, and the user postgres also. Then installed postgresql-8.1. But when I started to create a database, it shows some message like this.. Here is the output I got

could not connect to database postgres: could not connect to server

2008-04-11 Thread Jaisen N.D.
I have another problem with postgresql 8.1. I have uninstalled the postgresql-8.3 and removed its configuration files, and the user postgres also. Then installed postgresql-8.1. But when I started to create a database, it shows some message like this.. Here is the output I got

problem with pgadmin3 and postgres 8.3

2008-03-31 Thread Alex Samad
Hi It seems like the older version of pgadmin3 don't play well with postgres 8.3. The postgres people suggest (recommend) using version 1.8. But it seems like we can't have version 1.8 or anything greater than version 1.4 because wxwidgets isn't being maintained (well that is

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 w

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

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 wo

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

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

postgres install fails on sid

2007-10-07 Thread John Masters
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 this (as root) produces the following output:- Creating new cluster

Re: [GENERAL] postgres upgrade

2007-05-12 Thread Martijn van Oosterhout
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote: > I'm trying to upgrade from 8.1 to 8.2. > > Apparently the upgrade I just ran through installed a second database > on my server. > > I was hoping that the debian configuration would migrate this for me. > I recall there was once a t

Re: [GENERAL] postgres upgrade

2007-05-12 Thread Ray Stell
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote: > Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload > into 8.2? http://www.postgresql.org/docs/faqs.FAQ.html#item3.6 -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Conta

postgres upgrade

2007-05-12 Thread Tom Allison
I'm trying to upgrade from 8.1 to 8.2. Apparently the upgrade I just ran through installed a second database on my server. I was hoping that the debian configuration would migrate this for me. I recall there was once a time when it would ask you about moving data from old to new databases.

Re: Getting started with Postgres or MySQL

2007-02-03 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/03/07 12:26, David Baron wrote: > OK, I withdraw the question. Will find useful answers elsewhere or stay with > OpenOffice's DB (as I said, not all that bad!). > > The flame war has gotten too ugly. I think we can argue about the merits of >

Re: Getting started with Postgres or MySQL

2007-02-03 Thread David Baron
OK, I withdraw the question. Will find useful answers elsewhere or stay with OpenOffice's DB (as I said, not all that bad!). The flame war has gotten too ugly. I think we can argue about the merits of one of the other programs with a bit more common courtesy and civility and end the discussion

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 01:26:13PM +0100, Danesh Daroui wrote: > Roberto C. Sanchez wrote: > > > >Really? What should I learn? I've given specific things where your > >knowledge of/experience with databases is clearly deficient. Care to > >be specific and refrain from making sweeping statements

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Danesh Daroui
Ron Johnson wrote: > On 02/02/07 07:54, Dan H. wrote: >> Danesh Daroui wrote: > >>> 5. Again back to your example, yes, the PayPal web site offers you to >>> choose the data by using a combo box and not inserting it manually. So >>> the date which is sent to the database is definitely correct befo

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/02/07 07:54, Dan H. wrote: > Danesh Daroui wrote: > >> 5. Again back to your example, yes, the PayPal web site offers you to >> choose the data by using a combo box and not inserting it manually. So >> the date which is sent to the database is d

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Dan H.
Danesh Daroui wrote: > 5. Again back to your example, yes, the PayPal web site offers you to > choose the data by using a combo box and not inserting it manually. So > the date which is sent to the database is definitely correct before > inserting. This is one of the most pathetic things I've eve

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 12:15:31PM +0100, Danesh Daroui wrote: > > 1. The one who should learn something is you, and not me. So, I would > suggest you to learn something basic about database concepts and I don't > care if you ever come back or not! Really? What should I learn? I've given spec

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Danesh Daroui
1. The one who should learn something is you, and not me. So, I would suggest you to learn something basic about database concepts and I don't care if you ever come back or not! 2. You do not have to involve yourself in any single topic you see in the forum, specially if you are not asked to d

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 09:10:27PM -0500, Angelo Bertolli wrote: > > But you're coming from an angle where people know or must learn all of > that just before they're able to even start. Don't you see how not > having to learn that is faster for some people? > Ever have to share the road with so

Re: Getting started with Postgres or MySQL

2007-02-02 Thread Roberto C. Sanchez
On Fri, Feb 02, 2007 at 05:53:52AM +0100, Danesh Daroui wrote: > > What a useless and boring discussion you have started Ron!! Do you have > to just be against everyone who thinks MySQL has at least some good > features too? I just dropped the discussion when realized that it goes > nowhere, but i

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
or Microsoft? Or maybe you're an MCSE? >> >> It's confirmed. You *are* an MCSE. > > For that I may implement my next database with MySQL (instead of > Postgres like planned), just to spite you. I'll live. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (GNU/Linux)

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
next database with MySQL (instead of Postgres like planned), just to spite you. -- Angelo Bertolli Please remove my email address from your post when replying [Tech http://bitfreedom.com | Gaming http://heroesonly.com] -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of &q

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Danesh Daroui
e two are just different. >>> >> Mostly in letting people do rapid development without requiring a lot of >> forethought in database design. I know, I know, my argument is a lot > > That splatting noise is my hurl splatting onto the opposite wall. > > Remi

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Greg Folkert
now, my argument is a lot > > That splatting noise is my hurl splatting onto the opposite wall. > > Remind me never to hire you. Was that 3rd normal form? > > weaker these days with improvements made to Postgres. Legacy counts too > > in this case because when th

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
ifferent. >> > > Mostly in letting people do rapid development without requiring a lot of > forethought in database design. I know, I know, my argument is a lot That splatting noise is my hurl splatting onto the opposite wall. Remind me never to hire you. > weaker these day

Re: Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
ow, I know, my argument is a lot weaker these days with improvements made to Postgres. Legacy counts too in this case because when there is a big MySQL userbase out there that means more support. But, as you said before, that's not a technical merit. MySQL is to the database world what PHP

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 17:03, Roberto C. Sanchez wrote: > On Thu, Feb 01, 2007 at 04:37:39PM -0500, Angelo Bertolli wrote: [snip] > Yes, they were "fast" when computers were still slow. Unfortunately, > many people were willing to give up data integrity in excha

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
issue MySQL wins > because you can have it under the GPL. Postgres is under BSD. (I guess > that's arguable, but we are on a Debian list after all.) > It depends on whether your definition of "freeness" is biased toward developers or end users. Basically, on technical merits, MyS

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 01:16:18PM -0500, Angelo Bertolli wrote: > > (1) MySQL is shown to be faster in a single-user environment than > Postgres, especially with complicated SELECT statements > IIRC, this does not hold for transactional tables. So, we are back to the "if you

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
shown to be faster in a single-user environment than Postgres, especially with complicated SELECT statements (2) MySQL is a shorter learning curve for new users I think MSFT used to use those same arguments about why people should use Windows The fundamental difference is licensing.

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/01/07 07:31, Max Hyre wrote: > Roberto C. Sanchez wrote: >> On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: >>> In that same document, they give the reason for doing so: >>> "The reason for using the preceding rules in non-stric

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Ron Johnson
t; > (1) MySQL is shown to be faster in a single-user environment than > Postgres, especially with complicated SELECT statements > > (2) MySQL is a shorter learning curve for new users I think MSFT used to use those same arguments about why people should use Windows [snip] >

Re: Re: Getting started with Postgres or MySQL

2007-02-01 Thread Angelo Bertolli
like "MySQL is definitely your best choice" kind of answer with no clear indication as to why MySQL is a better choice in this case, so I'll give a couple of reasons: (1) MySQL is shown to be faster in a single-user environment than Postgres, especially with complicated SELECT state

Re: Getting started with Postgres

2007-02-01 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 04:18:23PM +0200, David Baron wrote: > Never expected to start a flame-war over this. > Hey. We're here to help :-) > I need visual tools to set the stuff up and run it and they are not evident. > Hmm. I like to work from the commandline. If I find myself needing to "b

Re: Getting started with Postgres

2007-02-01 Thread David Baron
Never expected to start a flame-war over this. I need visual tools to set the stuff up and run it and they are not evident. Actually, the OpenOffice database is not at all bad (except that it imports empty spreadsheet items as blanks (NOT EMPTY, NOT NULL). It can be readilly queried, reports ge

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Max Hyre
Roberto C. Sanchez wrote: > On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: > >> In that same document, they give the reason for doing so: >> >> "The reason for using the preceding rules in non-strict >> mode is that we can't check these conditions until the >> statement has begu

Re: Getting started with Postgres or MySQL

2007-02-01 Thread Dave Ewart
On Thursday, 01.02.2007 at 06:18 +0100, Danesh Daroui wrote: > About allowing corrupted data, it is not the responsibility of database > engine to verify if the data is valid or not since the database engine > only "Manages" data and not validate. It depends what you mean by 'validate'. The da

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 23:18, Danesh Daroui wrote: > Roberto C. Sanchez wrote: >> On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: >> [snip] > Maybe MySQL is not the best database engine in the world but it is one > the best engines. I have wor

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Thu, Feb 01, 2007 at 06:18:03AM +0100, Danesh Daroui wrote: > > Maybe MySQL is not the best database engine in the world but it is one > the best engines. I have worked on MySQL for several years and from four > years ago I have started to develop my own database engine inspired by > MySQL.

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
Roberto C. Sanchez wrote: On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: In that same document, they give the reason for doing so: "The reason for using the preceding rules in non-strict mode is that we can't check these conditions until the statement has begun executing.

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 02:54:01PM -0900, Joshua J. Kugler wrote: > > In that same document, they give the reason for doing so: > > "The reason for using the preceding rules in non-strict mode is that we can't > check these conditions until the statement has begun executing. We can't just > rol

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
On Wed, Jan 31, 2007 at 01:50:14PM -0900, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > > How do I get started here? > > > > First. Please do not use MySQL, unless you don't care about your data. > > Please stop this MySQL vs. PostgreSQL bashing. Eac

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 15:27, Ron Johnson wrote: > You're talking to someone who's been a DBA for 10 years; you will > not win this argument. Eh, so ya got three years on me. :) j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 17:54, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 14:20, Ron Johnson wrote: >> On 01/31/07 16:50, Joshua J. Kugler wrote: >>> On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > How do I get started here? Fi

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 14:20, Ron Johnson wrote: > On 01/31/07 16:50, Joshua J. Kugler wrote: > > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > >>> How do I get started here? > >> > >> First. Please do not use MySQL, unless you don't care about your data. > > > > Please sto

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 16:50, Joshua J. Kugler wrote: > On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: >>> How do I get started here? >> First. Please do not use MySQL, unless you don't care about your data. > > Please stop this MySQL vs. Postgre

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Joshua J. Kugler
On Wednesday 31 January 2007 13:19, Roberto C. Sanchez wrote: > > How do I get started here? > > First. Please do not use MySQL, unless you don't care about your data. Please stop this MySQL vs. PostgreSQL bashing. Each has their place. If users of MySQL don't care about their data, then I gue

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Roberto C. Sanchez
first line in the spreadsheet. This can, indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 au

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Ron Johnson
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/31/07 12:29, Danesh Daroui wrote: > David Baron wrote: [snip] > MySQL is definitely best choice. If you have not still installed > latest version of MySQL do it as following: Well, if you *insist* on starting a war, so be it. MySQL is a toy pie

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Danesh Daroui
indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 authorization. > Tried that. No ava

Re: Getting started with Postgres or MySQL

2007-01-31 Thread Clive Menzies
eadsheet. This can, indeed, be queried, sort of. > > I would like to get this data into a Postgres or MySQL database. Using > pgadmin3, I cannot get a connection connected. Does not accept my password. > Their docs cited Debian problems here and recommended md5 authorization. > T

Getting started with Postgres or MySQL

2007-01-31 Thread David Baron
this data into a Postgres or MySQL database. Using pgadmin3, I cannot get a connection connected. Does not accept my password. Their docs cited Debian problems here and recommended md5 authorization. Tried that. No avail. One can also simply say trust (localhost only). No avail. How do I get

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

postgres default username/password

2007-01-27 Thread Attila Horvath
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? Thx Attila -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Re: Problem in running postgres

2007-01-15 Thread Abu Zaher
On 1/15/07, Florian Kulzer <[EMAIL PROTECTED]> wrote: Check if you have the following two lines in your /etc/network/interfaces: auto lo iface lo inet loopback Had 2 add 'auto lo' in that file as it was missing. This solved the problem perfectly. My utmost thanks 2 everyone. Regards -- Ab

Re: Problem in running postgres

2007-01-15 Thread Matt Zagrabelny
ping is disjoint and not important to getting postgres to work with unix domain sockets. -- Matt Zagrabelny - [EMAIL PROTECTED] - (218) 726 8844 University of Minnesota Duluth Information Technology Systems & Services PGP key 1024D/84E22DA2 2005-11-07 Fingerprint: 78F9 18B3 EF58 56F5 FC85 C5CA 5

Re: Problem in running postgres

2007-01-15 Thread Florian Kulzer
On Mon, Jan 15, 2007 at 20:46:59 +0600, Abu Zaher wrote: > On 1/15/07, Douglas Tutty wrote: > > > >Is /etc/init.d/postgresql-8.1 starting __after__ networking? > > > >Yes, that's right. I found out that after my pc boots up, if i try iptraf, > i cant see any lo, i.e. any loopback interfaces. Only a

Re: Problem in running postgres

2007-01-15 Thread Abu Zaher
On 1/15/07, Douglas Tutty <[EMAIL PROTECTED]> wrote: Is /etc/init.d/postgresql-8.1 starting __after__ networking? Yes, that's right. I found out that after my pc boots up, if i try iptraf, i cant see any lo, i.e. any loopback interfaces. Only after I run network-admin, i can se the lo, then if

Re: Problem in running postgres

2007-01-14 Thread Douglas Tutty
On Sun, Jan 14, 2007 at 10:10:59AM +0600, Abu Zaher wrote: > Hi, > > I'm currnetly running Debian Sid. When my system boots up, I get this error: > > psql: could not connect to server: No such file or directory Is the server > running locally and accepting connections on Unix domain socket > "/va

Problem in running postgres

2007-01-13 Thread Abu Zaher
Hi, I'm currnetly running Debian Sid. When my system boots up, I get this error: psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? So i cant run postgresql. Moreover, wh

postgres installation on debian

2006-12-02 Thread Iuri Sampaio
wd” Thanks anyway iuri _ From: Iuri Sampaio [mailto:[EMAIL PROTECTED] Sent: Saturday, December 02, 2006 12:08 AM To: 'debian-user@lists.debian.org' Subject: users info Hi everyone What’s the file where the users info are located? Passwords, ids, … I need to change t

Re: moodle config tips? (or, PHP vs POSTGRES?)

2006-03-17 Thread Jay Zach
password > hostall all 127.0.0.1 255.255.255.255 password > seems to matter not a whit. no difference in results -- empty either way. > > we made sure postgres db user had a password, and used that to add > other users (

Re: moodle config tips? (or, PHP vs POSTGRES?)

2006-03-09 Thread will trillich
es '--with-zlib' '--without-pgsql' how do we enable postgresql-from-php? we've installed the various php stuff: ii libapache2-mod-php5 5.1.2-1.dotdeb.2 PHP 5 scripting language - apache 2.0 module ii php5-pgsql 5.1.2-1.dotde

Re: moodle config tips? (or, PHP vs POSTGRES?)

2006-03-09 Thread will trillich
meuser hostall all 127.0.0.1/32 md5 or the README recommendations of local all all password hostall all 127.0.0.1 255.255.255.255 password seems to matter not a whit. no difference in resu

Re: moodle config tips? (or, PHP vs POSTGRES?)

2006-03-08 Thread Roberto C. Sanchez
much taken care > of by the apt-get install process. (we did add "AcceptPathInfo on" > according to the instrux, as we're using apache2.) > > haven't found anything informative in the postgres logs, at all, and > apache logs reflect that it's doing what

moodle config tips? (or, PHP vs POSTGRES?)

2006-03-08 Thread will trillich
up nice as you please) and all the way down to step 8 is pretty much taken care of by the apt-get install process. (we did add "AcceptPathInfo on" according to the instrux, as we're using apache2.) haven't found anything informative in the postgres logs, at all, and apache log

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 >

Postgres question

2005-10-25 Thread Roberto C. Sanchez
I have the following directory structure under /var/lib/postgres on my server: $ sudo find /var/lib/postgres/ -type d /var/lib/postgres/ /var/lib/postgres/data /var/lib/postgres/data/base /var/lib/postgres/data/base/1 /var/lib/postgres/data/base/17141 /var/lib/postgres/data/base/17142 /var/lib

Re: Embedded SQL with Postgres

2005-08-01 Thread Frank Gevaerts
On Mon, Aug 01, 2005 at 03:13:54PM +0200, Stephan Meyen wrote: > Gregory Seidman wrote: > > If you must use embedded SQL, the libecpg-dev package includes/depends > > on the necessary libraries, headers, and ESQL preprocessor (ecpg). > > > > No, I have already tried that package... According to

Re: Embedded SQL with Postgres

2005-08-01 Thread Stephan Meyen
Gregory Seidman wrote: > Are you compiling legacy embedded SQL, or are you developing new code? > Embedded SQL was one of those bad ideas that existed because there was > nothing better at the time. Nowadays I'd recommend using either ODBC > (see unixodbc, unixodbc-bin, unixodbc-dev, and odbc-post

  1   2   3   4   >