On Thu, 2004-07-01 at 07:25, Jens Porup wrote:
> Oh, almost forgot:
>
> Some log errors that might help:
>
> From /var/log/postgresql/autovacuum_log:
>
> [2004-07-01 01:31:59 PM] Error: GUC variable stats_row_level must be enabled.
> [2004-07-01 01:31:59 PM]Please fix the pro
Are you sure you have the raw database files? The /home directory is
not where they are normally installed by default...
If those really are the database files I believe you can try to
reinstall postgres following the normal installation instructions but do
not do the initdb step. Skip to starti
I don't believe there is an option in pg_dump that current handles
that. It is the whole table / object or nothing at all. Depending on
the volume of transactions and frequency that you need to dump the data
will determine which solution works best for you.
Heavy volume and/or dumps multiple tim
On Thu, Jul 01, 2004 at 09:25:29AM -0600, Scott Marlowe wrote:
> > > > Yes, the following lines appear uncommented in my
> > > > /etc/postgresql/postgresql.conf:
> > > >
> > > > tcpip_socket = true
> > > > port = 5432
> > > >
> > > > But then:
> > > >
> > > > [EMAIL PROTE
"Lee Wu" <[EMAIL PROTECTED]> writes:
> I have some C functions (was compiled against 7.3.2, I think)
> Do I need to re-compile C functions against 7.4.3
Yes. You can hardly ever expect to move C functions across PG major
versions without at least recompiling them. (We try not to break
the sourc
Gene;
This is probably not much help but I was able to create and run this
function on 7.3.2 (running on FreeBSD 5.1) verbatim from your message.
Perhaps the function is corrupted? Maybe try dropping and recreating
the function.
Of course you wouldn't be able to factorial anything bigger than ab
Lee Wu wrote:
> I have some C functions (was compiled against 7.3.2, I think)
Recompile against 7.4.*.
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
On Wed, 2004-06-30 at 09:59, Sandro Dentella wrote:
> After a crash of the (frozen) system, postgreSQL issues a message:
>
> 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
> 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
> DET
"Vaughn, Adam (IMS)" <[EMAIL PROTECTED]> writes:
> Sorry to bother you but I was unable to find this problem after looking
> through the mailing list. I have postgres setup up on UNIX and I
> configured the appropriate files and followed the steps from the manual.
> After I initialized the database
Sandro Dentella <[EMAIL PROTECTED]> writes:
> After a crash of the (frozen) system, postgreSQL issues a message:
> 2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
> 2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
> DETAIL: could
Lee Wu wrote:
I have some C functions (was compiled against 7.3.2, I think)
Do I need to re-compile C functions against 7.4.3 or something else I
missed?
Yes, you need to recompile against 7.4.3
HTH,
Joe
---(end of broadcast)---
TIP 5: Have you check
After a crash of the (frozen) system, postgreSQL issues a message:
2004-06-30 17:51:39 [3165] LOG: connection authorized: user=sandro database=sia
2004-06-30 17:51:39 [3165] ERROR: could not access status of transaction 4011600129
DETAIL: could not open file "/var/lib/postgres/data/pg_clog/0EF1
unsubscribe-digest
pgsql-admin
hari
credit.com
550
15th Street
San Francisco
Ca 94103
(415) 901 1559
On Wed, 2004-06-30 at 06:54, Vincent van der Locht wrote:
> Hi,
>
> I have a question, I wnat to use a postgresql database in a embedded
> appliance, and thus want to keep the database as small as possible.
> I'd noticed that de diskspace only grows when i do an VACUUM; or a
> ./vacuumdb. Can th
Sorry to bother you but I was unable to find this problem after looking
through the mailing list. I have postgres setup up on UNIX and I
configured the appropriate files and followed the steps from the manual.
After I initialized the database server and started the postmaster I
attempted to query t
I have a set of database files from PostgreSQL where the
root partition crashed but the /home was saved. How do I remount
these databases with a new installation of the O/S and database
executables? N.B. I _don't_ have SQL dumps, just the actual raw
database files themselves
thanks in advance
D
Hi,
I have a question, I wnat to use a postgresql database in a embedded
appliance, and thus want to keep the database as small as possible.
I'd noticed that de diskspace only grows when i do an VACUUM; or a
./vacuumdb. Can this be explained why this is? or why this can be?
i use postgresql 7.4.
Hi,
I need to dump only partial content of my database, for example i want
to dump only records that has been insterted to the database from a
specific date.
I tried to use pg_dump/pg_export but did not find anything usefull.
I'm using postgres version 7.3 on Linux RH 7.3
any idea/direction ?
An idea only.
Ever try this?
select reltype from pg_class where relname='foo';
Then, delete the reltype from pg_class
To me goes fine.
Best wishes,
Guido
Nigel Bishop wrote:
Hi
I'm getting an error with pg_dump:
I'm using
pg_dump -v -C -U username database > ./dumpfile.dmp
and it errors with:
pg_du
I am new to Postgresql and am having problems getting functions working.
I have been following an example in the book "PostgreSQL" by Douglas &
Douglas Published by Developers Library.
I put the code in as a function (see end of email)
When I execute it from psql I get the following:
dev=# sele
Greetings,
I have some C functions (was compiled against 7.3.2, I think)
CREATE FUNCTION "mud" () RETURNS TRIGGER AS '/xxx/pgsql/lib/du.so',
'mud' LANGUAGE 'C';
It runs fine under 7.3.2, but I will get error when run the
above CREATE FUNCTION under 7.4.3.
ERROR: could not loa
Hi Mike,
I've tried that. It works!
Thanks a lot.
Harry
"mike g" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> What version of postgres did you install? If it is 7.4.2 or later then
> you must install the cygserver package and start that. ipc-daemon2 is
> not being used an
So these two statements seem to be somewhat contradictory.
What's the point of -C if not to create the database named in -d?
And why does -C -d template1 work but not -C -d ?
-tfo
[EMAIL PROTECTED] (Tom Lane) wrote in message news:<[EMAIL PROTECTED]>...
> Whatever database you name in -d has to
Jean-Christophe Weis <[EMAIL PROTECTED]> writes:
> The variable PGDATA2 is set and marked for export in the root shell where I
> start the server, but it is not passed into the server's environment.
No, because the start script is going to su to the postgres account,
and su is going to reset the e
select * from temptable where tempcolumn != 'blah'||'blah';
or
select * from temptable where tempcolumn <> 'blah'||'blah';
I could be wrong, but there may be an bug in the order of precedence.
If you try the above query, postgres will return:
ERROR: array value must start with "{"
Hello list,
I am a member of the french translation group for the PostgreSQL project.
I run PostgreSQL 7.2.1-2 on Debian Linux Woody (3.0r1).
I can't reproduce the steps described in Section 18.5 of the PostgreSQL 7.4
Documentation (Server Administration > Managing Databases > Alternative
Loca
On Wed, 2004-06-30 at 23:46, Jens Porup wrote:
> On Wed, Jun 30, 2004 at 11:33:04PM -0600, Scott Marlowe wrote:
> > On Wed, 2004-06-30 at 21:38, Jens Porup wrote:
> >
> > > The request tracker database setup script dies trying to connect to
> > > the database:
> > >
> > > DBI connect('dbn
Jens Porup <[EMAIL PROTECTED]> writes:
> I can connect manually to the database, like so:
> [EMAIL PROTECTED]:~# psql -d template1 -U rtuser -W
> Password:
> Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
> But it fails if I specify the host:
> [EMAIL
unsubscribe
The Hightower Group, Inc.
Custom Software Solutions Designed To Fit Your Business Like A Glove.
165 West Airport Road/Lititz, PA 17543
V:717-560-4002, 877-560-4002 x: 114
F:717-560-2825
www.hightowergroup.com
---(end of broadcast)--
Oh, almost forgot:
Some log errors that might help:
>From /var/log/postgresql/autovacuum_log:
[2004-07-01 01:31:59 PM] Error: GUC variable stats_row_level must be enabled.
[2004-07-01 01:31:59 PM]Please fix the problems and try again.
After doing a server restart, this l
30 matches
Mail list logo
