Re: [GENERAL] I can not drop a user/role because an object depent on it.

2009-10-01 Thread Ricky Tompu Breaky
On Wed, 30 Sep 2009 11:38:19 -0700 Adrian Klaver akla...@comcast.net wrote: On Wednesday 30 September 2009 10:43:35 am Ricky Tompu Breaky wrote: Dear my friends I can not drop a user because another object need it. How can I know which object need it? I really want to drop everything

[GENERAL] I can not drop a user/role because an object depent on it.

2009-09-30 Thread Ricky Tompu Breaky
Dear my friends I can not drop a user because another object need it. How can I know which object need it? I really want to drop everything inside my PostgreSQL, to reset my installation really from beginning. postgres=# drop user ivia; FEHLER: kann Rolle »ivia« nicht löschen, weil andere

Re: [GENERAL] I can not drop a user/role because an object depent on it.

2009-09-30 Thread Ricky Tompu Breaky
You've solved my Problem, Bill. I thank you very much, my friend Bill Moran. Highly appreciated. On Wed, 30 Sep 2009 13:45:52 -0400 Bill Moran wmo...@potentialtech.com wrote: In response to Ricky Tompu Breaky ricky.bre...@uni.de: Dear my friends I can not drop a user because

Re: [GENERAL] How should the first step of PostgreSQL implementation should be?

2009-09-27 Thread Ricky Tompu Breaky
On Sat, 26 Sep 2009 09:35:27 -0400 Bill Moran wmo...@potentialtech.com wrote: Ricky Tompu Breaky ricky.bre...@uni.de wrote: Dear my friends... I've installed postgresql-server on OpenSuSE11.1 successfully but I can't connect to it from psql. I did these steps: 1. I created

Re: [GENERAL] How should the first step of PostgreSQL implementation should be? (revised)

2009-09-27 Thread Ricky Tompu Breaky
On Sun, 27 Sep 2009 15:36:33 +0700 Ricky Tompu Breaky ricky.bre...@uni.de wrote: On Sat, 26 Sep 2009 09:35:27 -0400 Bill Moran wmo...@potentialtech.com wrote: Ricky Tompu Breaky ricky.bre...@uni.de wrote: Dear my friends... I've installed postgresql-server on OpenSuSE11.1

Re: [GENERAL] How should the first step of PostgreSQL implementation should be? (revised)

2009-09-27 Thread Ricky Tompu Breaky
Dear Alban. You've solved my problem Thank you 1000x. On Sun, 27 Sep 2009 11:36:09 +0200 Alban Hertroys dal...@solfertje.student.utwente.nl wrote: On 27 Sep 2009, at 10:44, Ricky Tompu Breaky wrote: RBI forgot to show you that I've done these steps too: postgres=# ALTER ROLE ivia

Re: [GENERAL] Newbie's question: How can I connect to my postgresql-server?

2009-09-27 Thread Ricky Tompu Breaky
you're help. You made so much steps further for me. On Sun, 27 Sep 2009 14:47:06 +0100 Sam Mason s...@samason.me.uk wrote: On Sat, Sep 26, 2009 at 03:00:41PM +0700, Ricky Tompu Breaky wrote: You've solved my several problem. But now I'm stucked on another problem which I know easy to anybody

Re: [GENERAL] Newbie's question: How can I connect to my postgresql-server?

2009-09-26 Thread Ricky Tompu Breaky
:47:23AM +0700, Ricky Tompu Breaky wrote: sussy:~ # psql -U ricky -W I didn't realize you were running commands as root. My comments to the mailing list still apply, but this is normally frowned upon as it's easy to kill the system by accident. Also, when Linux starts getting viruses

[GENERAL] How should the first step of PostgreSQL implementation should be?

2009-09-26 Thread Ricky Tompu Breaky
Dear my friends... I've installed postgresql-server on OpenSuSE11.1 successfully but I can't connect to it from psql. I did these steps: 1. I created a new opensuse11.1-linux login account + its password (username: ivia) with YaST2; 2. i...@sussy:~ su postgres -c psql postgres Passwort: Dies

[GENERAL] Newbie's question: How can I connect to my postgresql-server?

2009-09-24 Thread Ricky Tompu Breaky
Dear my friends I am still new in PostgreSQL. Usually I use MySQL on OpenSuSE. I just have installed postgres with: zypper install postgresql-server. The installation looked OK. As post-installation process, I've done: sussy:~ # rcpostgresql status Checking for PostgreSQL:

Re: [GENERAL] Newbie's question: How can I connect to my postgresql-server?

2009-09-24 Thread Ricky Tompu Breaky
On Thu, 24 Sep 2009 19:57:55 +0100 Sam Mason s...@samason.me.uk wrote: On Fri, Sep 25, 2009 at 01:47:03AM +0700, Ricky Tompu Breaky wrote: I am still new in PostgreSQL. Usually I use MySQL on OpenSuSE. Welcome over, PG is *normally* much better behaved than this and generally gives very

[GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.

2009-09-11 Thread Ricky Tompu Breaky
Dear my friends, I want to install PostgreSQL in my Debian Lenny box. I can't install PostgreSQL with aptitude: aptitude install postgresql . It seems that the aptitude can not find the postgresql. This is my '/etc/apt/sources.list'. I have done aptitude update too. And it was completed

Re: [GENERAL] Installing postgresql on Debian Lenny--my /etc/apt/sources.list.

2009-09-11 Thread Ricky Tompu Breaky
main contrib non-free deb http://ftp.bononia.it/debian lenny-proposed-updates main contrib non-free deb http://ftp.debian.org/debian/ lenny main contrib non-free === On Fri, 11 Sep 2009 09:56:33 +0300 Peter Eisentraut pete...@gmx.net wrote: On Fri, 2009-09-11 at 13:17 +0700, Ricky Tompu Breaky