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 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 t

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 wrote: > In response to Ricky Tompu Breaky : > > > Dear my friends > > > > I can not drop a user because another o

[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 Ob

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

2009-09-27 Thread Ricky Tompu Breaky
res. I really appreciate you're help. You made so much steps further for me. On Sun, 27 Sep 2009 14:47:06 +0100 Sam Mason 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

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 wrote: > On 27 Sep 2009, at 10:44, Ricky Tompu Breaky wrote: > > > RB>I forgot to show you that I've done these steps too: > > postgres=# ALTER ROLE

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 wrote: > On Sat, 26 Sep 2009 09:35:27 -0400 > Bill Moran wrote: > > > Ricky Tompu Breaky wrote: > > > > > > Dear my friends... > > > > > > I've installed postgresql-server on OpenSu

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 wrote: > Ricky Tompu Breaky 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

[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

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

2009-09-26 Thread Ricky Tompu Breaky
ling 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 it'll be able to infect the whole system if you do > this rather than just your (unprivileged) account. If you've not > used

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 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 giv

[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] Installing postgresql on Debian Lenny-->my /etc/apt/sources.list.

2009-09-11 Thread Ricky Tompu Breaky
/lg3d/debian stable contrib deb http://ftp.bononia.it/debian lenny 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 wrote: > On F

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

2009-09-10 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 p