"Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
>> Tom Lane wrote:
>>> We need to think about whether this bug is serious enough to justify a
>>> quick 7.3.5 release. I'm leaning to the idea that it is not, because
>>> if it were, we'd have heard about it
Have you looked in the src/contrib/reindex directory?
---
Dani Oderbolz wrote:
> Hi guys,
> I wnated to write a nice littel script to regenerate Indexes,
> but I am struggling with the Array type...
> (Can anydody tell me wh
that's what i was looking for. thanks. and i see what you mean
about not really trusting that the data really is all there.
still, most is better than none.
again, thnks.
pg
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [E
More information:
I'm running PostgreSQL version 7.3.2
on linux RH 8.0 (Linux version 2.4.18-14smp
([EMAIL PROTECTED]) (gcc
version 3.2 20020903 (Red Hat Linux 8.0 3.2-7))
After the most recent 'crash' I went into
single user mode, and did the following:
1) reindex database dbname --> 5 minut
> It's really too bad that your gdb backtrace didn't show anything past
> the write_syslog level (which is an elog subroutine). If we could see
> whether the elog had been issued from a signal handler, and if so what
> it had interrupted, we'd have an idea whether this is a known syslog
> deficien
I'm trying to set up my Linux machine with ssl, but it fails.
- compiled --with-openssl
- ssl =true in postgresql.conf
- generated server.crt and server.key as recommended in Administrator's
Guide
Checking:
- if server.crt or server.key are missing, postmaster won't start
- SHOW ssl returns "on"
On Wed, Jul 30, 2003 at 01:23:25PM -0400, Andrew Sullivan wrote:
>
> At base, however, you want to use one of the sample rc scripts into
> /etc/rc[n].d , and make a symlink to it from /etc/init.d. I believe
Doh! The other way around, actually. Boy, it's embarassing
tripping over your own shoel
On Wed, Jul 30, 2003 at 10:36:03AM -0400, [EMAIL PROTECTED] wrote:
>
> given that someone (else) deleted the pg_xlog directory, or that it got
> otherwise corrupted, is there a way to regenerate the database, given
> that all the data is still safely tucked away in $PGDATA/base ???
Well, I'm not
On Wed, Jul 30, 2003 at 10:34:51AM -0500, Kris Kiger wrote:
> appear that PG tries to start at all durring the bootup process. I'm
> still relatively new to linux, but from my understanding, I need to be
> looking in the /etc/init.d directory for boot setup information. Does
> anyone know of a
[EMAIL PROTECTED] writes:
> Neither of those make a whole lot of sense to me, though:
> 1. The Postgresql backend shouldn't be getting any signals (at least none
> external to Postgresql).
Hm. Postgres does sometimes issue elog messages from inside a signal
handler. I doubt that it would do so w
Greetings!
I'm a dba new to postgresql and I wanted to
learn about these two error messages. I am
getting these errors quite often and I'm
wondering what it might be that is causing
them. Could it be bad indexes? ...I've opened
the database up in single user mode, and ran
a 'reindex dat
>> And the other:
>> 19720 pts/2S 0:04 postgres: award Trucking [local] UPDATE
>> (gdb) bt
>> #0 0x4021cec6 in sigsuspend () from /lib/libc.so.6
>> #1 0x424b6218 in __pthread_wait_for_restart_signal ()
>>from /lib/libpthread.so.0
>> #2 0x424b79a0 in __pthread_alt_lock () from /lib/l
A good start would be to read the logfile. A lot of startup problems can
be solved from the messages within. It could be something as simple as
trying to start PG as root.
Kris Kiger wrote:
I've installed postgres 7.3.3 on one of my debian machines. On other
installations postgres is started
Did I forget a step in setting up SSL? Is their a way to find out if SSL
is in use on a session or that it was compiled properly into the
back-end and client?
Tom Lane wrote:
Renney Thomas <[EMAIL PROTECTED]> writes:
I _can't_ get psql to connect with ssl on.
You're not showing us any
"Bruce Momjian" <[EMAIL PROTECTED]> wrote:
> Tom Lane wrote:
> > We need to think about whether this bug is serious enough to justify a
> > quick 7.3.5 release. I'm leaning to the idea that it is not, because
> > if it were, we'd have heard about it from the field before now. In
> > pre-7.4 code
"Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> but you agree anyway that should not possible delete
> a user that own DB object or at least change the owner
> to postgres?
If you do it the approved way, with DROP USER, you'll find there's
already an interlock:
regression=# create user foo;
CREAT
Mendola Gaetano wrote:
CREATE TABLE foo (field_a
field_b
..
fast_search BOOLEAN NOT NULL DEFAULT 1,
time_stamp TIMESTAMPTZ NOT NULL DEFAULT now()
);
CREATE INDEX idx_fast_search ON foo ( fast_search ) where fast_search = 't';
for each field to index:
CREATE INDEX idx_field_a ON foo ( field_a
"Tom Lane" <[EMAIL PROTECTED]> wrote:
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > "Tom Lane" <[EMAIL PROTECTED]>
> >> Nope. I don't know how John got into this state, but it most
definitely
> >> was not that way. Try it.
>
> > Here it his:
>
> No, you're looking at the result of psql -l.
I've installed postgres 7.3.3 on one of my debian machines. On other
installations postgres is started automatically on machine bootup.
However, on one installation it fails to do so. In fact, it doesn't
appear that PG tries to start at all durring the bootup process. I'm
still relatively ne
On Wed, Jul 30, 2003 at 05:14:12PM +0200, Dani Oderbolz wrote:
> >On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote:
> >If you read my post carefully you will actually see it's the _same_
> >possibility :)
> >
> >But DRDB is only part of the solution - you also need something like
> >he
Ragnar Kjørstad wrote:
On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote:
If you read my post carefully you will actually see it's the _same_
possibility :)
But DRDB is only part of the solution - you also need something like
heartbeat to manage what node postgresql runs on.
Um, sor
"Dani Oderbolz" <[EMAIL PROTECTED]> wrote:
> Mendola Gaetano wrote:
>
> >you can easilly accomplish this using a partial index.
> >
> >
> Would that really work with a view?
> Can you post a syntax example for this?
CREATE TABLE foo (
field_a
field_b
..
fast_search BOOLEAN NOT NULL DEFAULT 1,
"Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> "Tom Lane" <[EMAIL PROTECTED]>
>> Nope. I don't know how John got into this state, but it most definitely
>> was not that way. Try it.
> Here it his:
No, you're looking at the result of psql -l. What John was showing us
was the actual contents of
Hi,
When i "make install", the installation abort compiling jdbc.
Please, can say me what is wrong?
Thanks!
<>
java -version:
java version "1.3.1_02"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1_02-b02)
Java HotSpot(TM) Client VM (build 1.3.1_02-b02, mixed mode)
compil
given that someone (else) deleted the pg_xlog directory, or that it got
otherwise corrupted, is there a way to regenerate the database, given
that all the data is still safely tucked away in $PGDATA/base ???
pg
---(end of broadcast)---
TIP 3: if p
"Tom Lane" <[EMAIL PROTECTED]>
> "Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> > ""John P. Looney"" <[EMAIL PROTECTED]> writes:
> >> bbadmin | | SQL_ASCII
>
> > For sure a way to obtain this inconsistence is delete the owner of
> > a db and voila' a DB result to have no ow
Renney Thomas <[EMAIL PROTECTED]> writes:
> I _can't_ get psql to connect with ssl on.
You're not showing us any evidence to support that statement ...
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading th
"Mendola Gaetano" <[EMAIL PROTECTED]> writes:
> ""John P. Looney"" <[EMAIL PROTECTED]> writes:
>> bbadmin | | SQL_ASCII
> For sure a way to obtain this inconsistence is delete the owner of
> a db and voila' a DB result to have no owner.
Nope. I don't know how John got into
On Wed, Jul 30, 2003 at 01:10:06PM +0200, Dani Oderbolz wrote:
> >One possibility is to run postgresql (regular postgresql - no patches
> >required) controlled by heartbeat (http://www.linux-ha.org/) on two
> >nodes. Heartbeat will then make sure that only one of the nodes are
> >active at any time
"Arthur Ward" <[EMAIL PROTECTED]> writes:
> FWIW, since I already went to the trouble (and for the sake of people
> searching the archives in the future), here's what I was seeing in the
> backtraces after rebuilding this afternoon:
> This process:
> 19763 pts/2S 0:00 postgres: checkpoint
sorry, when i referred to "disk space used" i meant the actual
amount used by live rows. if i insert 1000 rows then delete
999 of them, the disk file will be the size of the 100 row
container (make that 1000, not 100 - i cannot backspace here)
until i do a "vacuum full" - which does a table lock, w
Ragnar Kjørstad wrote:
On Mon, Jul 21, 2003 at 06:11:15PM -0400, Renney Thomas wrote:
I am having a hard time selecting a Replication/Failover/HA solution for
PGSQL. What is troubling is the number of solutions available in various
states of development. Does the fact that dbmirror and rserv
Mendola Gaetano wrote:
you can easilly accomplish this using a partial index.
Would that really work with a view?
Can you post a syntax example for this?
Regards,
Dani
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unre
On Wed, 30 Jul 2003, Anagha Joshi wrote:
> Hi All,
> I'm using PG-7.2.4 on Solaries.
> When I do:
>
> template1=# select time(6576);
> ERROR: TIME(6576) precision must be between 0 and 13
>
> Where am I wrong?
IIRC time(n) refers to the type time with a precision of n
and n is limited as stated
On Tue, 29 Jul 2003 17:41:08 -0400, Tom Lane wrote:
> Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
>> On Tue, 29 Jul 2003, Benjamin Thelen (CCGIS) wrote:
>>> I would like to change the ownership of a database.
>
>> UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE
>> usename='new_
Hi All,
Im using PG-7.2.4 on Solaries.
When I do:
template1=# select time(6576);
ERROR: TIME(6576) precision must be between 0 and 13
Where am I wrong?
Pls. help
Thanks,
Anagha
36 matches
Mail list logo