are on the same host.
What could be the problem.
thx (and soory for my english),
Bernd
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
> Do you have TCP/IP activated in postgresql.conf ? Are you trying to
> connect via localhost (127.0.0.1) or some other route?
I start the Server with the -i option, so TCP/IP is activated, isn't it?
I want to connect by localhost to my database.
thx,
Bernd
--- Ursprünglich
I recvive still the same error-message.
thx,
Bernd
--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:14
Von: "Joshua D. Drake" <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED]
Betreff: Re: [GENERAL] Cannot connect to Database
> [EMAIL PROTECTED] wrote:
> >>Do
I still recive the same error-message
thx,
Bernd
--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:13
Von: javier wilson <[EMAIL PROTECTED]>
An: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Betreff: Re: [GENERAL] Cannot connect to Database
> have you tried connecting to
> Did you restart Postgresql after editing your pg_hba.conf file?
Yes, I did.
thx,
Bernd
--- Ursprüngliche Nachricht ---
Datum: 08.02.2005 19:31
Von: Scott Marlowe <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED]
Betreff: Re: [GENERAL] Cannot connect to Database
> Did you restart Post
I've already shutdown my firewall.
My OS is Linux (SuSE 9.2 64Bit)
My postgre version is 7.4.6
and the port is on listen-mode
[EMAIL PROTECTED]:/home/bernd> netstat -an | grep 5432
tcp0 0 0.0.0.0:54320.0.0.0:*
LISTEN
tcp0 0
ql on the same machine as your applicaiton?
>
> Are you sure postgresql is starting up in the directory you think it
is?
>
> On Tue, 2005-02-08 at 12:44, [EMAIL PROTECTED] wrote:
> > > Did you restart Postgresql after editing your pg_hba.conf file?
> >
> > Yes, I did.
>
s are encouraged to carefully test their platforms when upgrading.
Checks show that at least RHEL6 and RHEL7 have the same issue, too.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n definitions shipped shows
clearly that this is something we cannot ignore anymore.
> [1]
> http://www.postgresql.org/message-id/CAEYLb_UTMgM2V_pP7qnuKZYmTYXoym-zNYV
> bwoU79=tup8h...@mail.gmail.com
Yeah, i know this discussion and SR clearly widens the window for such
things to happen
e. I suppose that in
SERIALIZABLE or REPEATABLE READ transaction isolation your proposal still
doesn't return the tuples you'd like to see.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
transform/analyse phase and
its snapshot is taken much later. Looks like we need something that
analyses a utility statement to get its lock before executing.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscrip
time
ago. I forgot about it, but i think there's value in it to backpatch.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hi list,
I have a view defined as:
CREATE VIEW kkm_ergebnisse.v_protokoll_details_mit_dauer AS
SELECT
id,
schritt,
objekt_typ,
objekt_id,
zeit,
rechenweg_thema,
rechenweg_variante,
rechenweg_stoffgruppe,
formel_inhalt,
formel_stoff,
formel_variablen,
ergebnis_variable,
e
"duplicate" index? Think about partial
indexes, where we actually _want_ to have multiple indexes for certain
ranges on the same column.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
ore" is not internal
or external command, not runnable program or bat file. Why did I input
like "mydb => select * from .;" but PG suppose what I enter is "more"?
psql uses more to paginate results of your SELECT command. Seems like
'more' is missing in y
n cygwin, only. For others the
default is more, unless you override this via PAGER.
--
Thanks
Bernd
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
e (detect the sql-statement and the associated plan as two
separate statements)...
bernd.
Von: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org] Im Auftrag von Chris Barnes
*EXTERN*
Gesendet: Freitag, 20. November 2009
ct solution, but it might work for you.
>
But that requires to adjust all SELECTs which uses this table function, since
SETOF RECORD requires you to specify a column list. Maybe you can build
something like that using a table's implicit type.
Thanks,
Bernd
---
list for this, see my reply there.
Thanks,
Bernd
---(end of broadcast)---
TIP 6: explain analyze is your friend
ss. Remove the SELECT and use
the LOCK TABLE command within the transaction which does the sync for you.
Bernd
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
ise generic errors with RAISE EXCEPTION.
See
http://www.postgresql.org/docs/8.2/interactive/plpgsql-control-structures.html#PLPGSQL-ERROR-TRAPPING
for details.
Bernd
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore
n't it be easier to wrap your tests into
self-contained testfunctions like
SAVEPOINT A;
SELECT testcase1();
ROLLBACK TO A;
SELECT testcase2();
ROLLBACK TO A;
...
and to evaluate return codes into your application? Maybe someone knows better,
but
that's the only solution that comes to
e requested behavior. The way the rewriter handles it's query qualifications
would have to
be redesigned as well, i think, but i don't know what can of worms there are,
too
Bernd
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
DROP VIEW IF EXISTS combined with a following CREATE VIEW, instead.
Bernd
---(end of broadcast)---
TIP 6: explain analyze is your friend
current
active "master" on your cluster. Connecting to the master node should always
happen through this
IP adress, so you always "know" you are on the master when using this IP. You
could then spread read
operations along the IPs assigned directly to each node, "declari
L
standard
tells us to do. The CHECK OPTION is an example, this can't be modeled
using rules only.
Bernd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
value) VALUES(NEW.id, NEW.value);
CREATE OR REPLACE RULE insert_200
AS ON INSERT TO sessions
WHERE NEW.id BETWEEN 101 AND 200
DO INSTEAD
INSERT INTO sessions_200(id, value) VALUES(NEW.id, NEW.value);
INSERT INTO sessions(value) VALUES('bernd');
SELECT * FROM sessions;
id | value
+--
lib looks like this on my MDK 10.0 installation then:
libreadline.so -> libreadline.so.4.3
libreadline.so.4 -> libreadline.so.4.3
libreadline.so.4.1 -> ../lib/libreadline.so.4
libreadline.so.4.2 -> ../lib/libreadline.so.4
libreadline.so.4.3
[...]
--
Bernd
--
t are needed
for UDFs.
Have a nice day,
dito
--
Thanks
Bernd
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
szenarios, where the GEQO has improved the query plan generation
in contrast to "traditional" solutions? This will be very helpful (and
interesting)
Thanks in advance,
Bernd
---(end of broadcast)---
TIP 1: subscribe and unsubscrib
Tom Lane wrote:
Bernd Helmle <[EMAIL PROTECTED]> writes:
But what means "enough tables"?
GEQO_THRESHOLD or more. You can set that anywhere you like (I think the
default is 11 or 12, which is about where the standard exhaustive-search
planner becomes painfully slow).
regards,
---
TIP 4: Don't 'kill -9' the postmaster
I don't know if it works, just a thought:
You can examine, wether contrib/dblink works in conjunction with
tsearch[2]. If this is runnable, you can create a "search database" with
dblink'ed search queries/views o
t complex, but it seems to work right now, although
there's many i have to do in the next days.i will post as soon as I
have a working proof-of-concept. Please note that i'm heading for
SQL92-compliance, SQL99 seems a todo for the next-generation.
Bernd
---
(under MacOS X). Hence my question (before I start digging): Can
anyone on the list confirm that this is doable (w/o too much hassles
) with PostGresQL? Thx for your time! Best, Bernd
---(end of broadcast)---
TIP 7: don't forget to increase
Dear list, many thanks to all of you who've replied in such a
helpful way -- your support is much appreciated! Have a nice
weekend, Bernd
---(end of broadcast)---
TIP 6: Have you searched our list archives?
)---
TIP 8: explain analyze is your friend
Bernd
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
36 matches
Mail list logo
