On Tue, Nov 14, 2006 at 04:29:05PM -0800, Shelby Cain wrote:
> You are assuming I have the source for the library and although I've
> asked nicely via email Microsoft hasn't responded to my requests for
> the source code to kernel32.dll. ;)
I see, you're doing something rather unsupported...
> R
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
solves your problem
--
Teodor Sigaev E-mail: [EMAIL PROTECTED]
WWW: http://www.sigaev.ru/
---(end of broadcast)---
T
On Tuesday November 14 2006 11:51 pm, Matthew T. O'Connor wrote:
> Ed L. wrote:
> > Does autovac maintain its state/counters across restats as
> > to who need to be vacuumed/analyzed? Or does killing
> > autovac cause it to reset the counters for the
> > vacuum/analyze threshholds?
>
> Depends on
Ed L. wrote:
Does autovac maintain its state/counters across restats as to who
need to be vacuumed/analyzed? Or does killing autovac cause it
to reset the counters for the vacuum/analyze threshholds?
Depends on the version. The contrib autovacuum does not maintain state
through a restart.
On Tuesday November 14 2006 1:02 pm, Ed L. wrote:
> On Tuesday November 14 2006 12:56 pm, Jim C. Nasby wrote:
> > You don't have the vacuum cost delay settings set
> > unreasonably high, do you?
>
> On Tuesday November 14 2006 12:56 pm, you wrote:
> > You don't have the vacuum cost delay settings s
Does autovac maintain its state/counters across restats as to who
need to be vacuumed/analyzed? Or does killing autovac cause it
to reset the counters for the vacuum/analyze threshholds?
TIA.
Ed
---(end of broadcast)---
TIP 1: if posting/reading
X-No-Archive: true Excellent.. thank you for that! D.Shane Ambler <[EMAIL PROTECTED]> a écrit : Desmond Coughlan wrote:> X-No-Archive: true> > Just had a thought. If you see .. > > http://www.chez.com/desmondcoughlan/unix/cdi_gt.sqlWith the ISBN number you may want to look at contrib/isn - th
Desmond Coughlan wrote:
X-No-Archive: true
Just had a thought. If you see ..
http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql
With the ISBN number you may want to look at contrib/isn - this adds
ISBN types.
If not then varchar(12) won't hold the new ISBN-13 format that is in
Desmond Coughlan wrote:
And our ultimate aim is for a barcode reader to be used by the librarian.
> Any good sources to learn about that ?
I have only had a little exposure to barcode scanners - the one that a
client used just behaved as a keyboard, so there was no programming to
support it
On Tue, Nov 14, 2006 at 01:20:38PM -0800, Don Laurine wrote:
> In the postgres log I am getting the following:
>
> ERROR: type "i" does not exist
>
> What is the cause of this error and/or how do I track it down?
One possibility is that a query is trying to cast a value to the
"i" type, either
X-No-Archive: true A really weird thing. This .. http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql .. works almost perfectly. Except for this error .. 'psql:/usr/local/pgsql/bibliotheque.sql:54: ERROR: relation "titles" does not exist' I wrote http://www.chez.c
X-No-Archive: true More tables and fewer columns in the tables? I *like* it! It hadn't occurred to me do it that way. Will this work ? http://www.chez.com/desmondcoughlan/unix/bibliotheque.sql I haven't tested it yet, which brings me to two questions... a. will it work even
Hi,
Have you added the ability to store reservations, if a book is out. Maybe
having a table for this,
requests/reservations
id pk
user_id fk
item_id fk
date_requested (so that the first person on the list for this book is
notified)
Also, I'll assume there is more than one book per title, thu
On Wednesday 15 November 2006 01:41, you wrote:
> On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
> >> I'd think starting a standalone backend and issuing a "reindex database"
> >> should be enough to get him started. Now, the problem is figuring _how_
> >> the index got in that state;
X-No-Archive: true Just had a thought. If you see .. http://www.chez.com/desmondcoughlan/unix/cdi_gt.sql .. I'd planned to have one table 'stock' and a column in that table for 'format', as we have books, CDs, DVDs, etc... What about if I had a separate table for books, another f
X-No-Archive: true OK, I think I understand. So the *.sql file that I provided doesn't need to be changed per se, as in the 'stock' table is OK (maybe change it 'stock_general')? I'd just add another table, with a foreign key 'pointing' back to 'stocks_general'... and a sequence, of course, s
You are assuming I have the source for the library and although I've asked
nicely via email Microsoft hasn't responded to my requests for the source code
to kernel32.dll. ;)
Regardless, even if I had the source, adding PG_MODULE_MAGIC to an arbitrary
dll that has no need to know anything about
Apologies, my reply should have gone to the list.
To answer your question, the sort of thing I'm thinking of is the
case where, maybe, one copy of a book is missing a page or two (not
unknown in a school library) - the first scenario can't record this,
nor can it tell which unlucky borrower ended
On Tue, 14 Nov 2006 21:26:02 +0200, Igor Shevchenko wrote:
>> I'd think starting a standalone backend and issuing a "reindex database"
>> should be enough to get him started. Now, the problem is figuring _how_
>> the index got in that state; or even _what_ index is the problematic
>> one. (I th
On Tue, Nov 14, 2006 at 02:46:41PM -0800, Shelby Cain wrote:
> Could someone give me some general hints as to what modifications I'd
> need to make in the 8.2 source tree in order to remove the
> PG_MODULE_MAGIC requirement for loading shared libraries into the
> backend? Is there any chance this
"Rob Owen" <[EMAIL PROTECTED]> writes:
> Breakpoint 1, 0x000119dc in errfinish () from postmaster
> (gdb) bt
> #0 0x000119dc in errfinish () from postmaster
> #1 0x0001a680 in AllocSetAlloc () from postmaster
> #2 0x00012a1c in MemoryContextAlloc () from postmaste
Once upon a time, I put a question regarding deadlocks to the group,
and Tom Lane immediately answered with this:
>The guy waiting on the tuple-specific lock is second in
>line to actually mung the tuple. Whoever is first in line behind the
>current tenant will be blocked trying to acquire ShareL
X-No-Archive: true Thanks. The main uses will be .. 1. available on www to query catalogue (open to everyone) 2 avail. from the web for teachers and students to check their library account (necessitates an account) 3. available in the library itself both on a web interface (to allow the
Could someone give me some general hints as to what modifications I'd need to
make in the 8.2 source tree in order to remove the PG_MODULE_MAGIC requirement
for loading shared libraries into the backend? Is there any chance this could
be made into a configurable option so the user can choose th
Hi all,
We're trying to use connectby to transform a tree into an ordered set
of rows, specifically requirements rows.
We have data stored in a table with
keyid and parent_id, as described in the examples for
keyid is also the primary key of a table A, which has the field
A.seq_number.
We
That looks like the solution to my problem, thanks!...I tried running it
on my 8.0.8 server, but it wasn't found, I assume that's an 8.1 only
function?
Martijn van Oosterhout wrote:
On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote:
I am once again dealing with that age old pro
Hello,
Does anyone know if it is possible to use SAN Splitting (the function of
splitting a mirror of disks so that there are two idential copies of a
Postgres Instance)? The reason that I ask is because I'm working on a
Hashing database to scale postgres to the moon and I'd like to be able to
c
On Tue, Nov 14, 2006 at 03:54:42PM -0600, John McCawley wrote:
> I am once again dealing with that age old problem of retrieving the
> value of your inserted serial field in VB. I am fully aware that I can
> manually pull the currval or nextval from my sequence, but I consider
> having to manua
In the postgres log I am getting the following:
ERROR: type "i" does not exist
What is the cause of this error and/or how do I track it down?
I am running postgres ver 8.1.4 under redhat 4
Thanks for any help
Don
begin:vcard
fn:Don Laurine - DOH
n:Laurine;Don
org:Northwest River Forecast Cent
I am once again dealing with that age old problem of retrieving the
value of your inserted serial field in VB. I am fully aware that I can
manually pull the currval or nextval from my sequence, but I consider
having to manually deal with an auto-generated database object an
*extremely* inelega
On Tue, 2006-11-14 at 15:04, [EMAIL PROTECTED] wrote:
> Can I install a PostgreSQL DB on a Novell LAN drive or must it be on a
> server?
Do you mean running postgresql on a linux or windows machine with the
$PGDATA directory located on a Novell / NFS / Samba mount, or do you
mean running postgres
Can I install a PostgreSQL DB on a Novell LAN drive or must it be on a
server?
Thanks,
Michael
---(end of broadcast)---
TIP 6: explain analyze is your friend
Cabbar Duzayak wrote:
Hi,
We have huge amount of data, and we are planning to use logical
partitioning to divide it over multiple machines instances. We are
planning to use Intel based machines and there is not much updates but
mostly selects. The main table that constitutes this much of data ha
Breakpoint 1, 0x000119dc in errfinish () from postmaster
(gdb) bt
#0 0x000119dc in errfinish () from postmaster
#1 0x0001a680 in AllocSetAlloc () from postmaster
#2 0x00012a1c in MemoryContextAlloc () from postmaster
#3 0x000100108c28 in _bt_search () from po
"Rob Owen" <[EMAIL PROTECTED]> writes:
> Attached to backend postmaster and got the following. Hope this helps.
Nope, you got the postmaster itself there, you need to look at the new
child process. (It should look like "postgres: startup" in ps.)
regards, tom lane
--
On Tuesday November 14 2006 12:56 pm, Jim C. Nasby wrote:
> You don't have the vacuum cost delay settings set unreasonably
> high, do you?
On Tuesday November 14 2006 12:56 pm, you wrote:
> You don't have the vacuum cost delay settings set unreasonably
> high, do you?
I'm not sure. Here's what we
On Tue, Nov 14, 2006 at 12:53:56PM -0700, Ed L. wrote:
> On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
> > On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> > > I have an 8.1.2 autovac which appears to be hanging/blocking
> > > every few days or so, but we're don't understand wha
On Tuesday November 14 2006 12:49 pm, Jim C. Nasby wrote:
> On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> > I have an 8.1.2 autovac which appears to be hanging/blocking
> > every few days or so, but we're don't understand what's
> > causing it. I wasn't able to catch a backtrace before
On Tue, Nov 14, 2006 at 01:31:28PM -0500, Carlson, James (Jim) wrote:
> I have an old server that is still working faithfully. It is running Red
> Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
> I am concerned is closer than I want it to be, I have set up a shinny
> new s
On Tue, Nov 14, 2006 at 11:20:30AM -0700, Ed L. wrote:
> I have an 8.1.2 autovac which appears to be hanging/blocking
> every few days or so, but we're don't understand what's causing
> it. I wasn't able to catch a backtrace before we killed it. I
> do not see autovac locks in the pg_locks vie
On Tue, Nov 14, 2006 at 06:08:44AM -0800, [EMAIL PROTECTED] wrote:
> Good morning,
>
> I've recently just inherited a PostgreSQL database that is a back end
> for some logistics software we use here. We have our own Oracle
> servers in our group on faster machines with automated backup so we
> wo
And, when coming up with the use cases you should be working with the
people who will actually be using the application. Wrt barcode
scanners, they typically just translate the barcode into a number. So,
you'll need a barcode printer to print barcodes for your ids to put on
the books.
Ben w
You want to do count(DISTINCT part_id) and count(DISTINCT desc).
On Sat, Nov 11, 2006 at 04:25:51PM -0800, Kojak wrote:
> Here's a description of the scenario. The question I'm asking follows
> the description.
> 3 tables
> table1:
> job_no int4
> rate1 float4
> qty1 float4
> rate2 float4
> qty2
On Thu, Nov 09, 2006 at 04:37:23PM +0100, Alban Hertroys wrote:
> 'lo list,
>
> I have a plpgsql SP where I loop through a cursor. I have an internal
> variable that keeps the previous row, so that I can compare it with the
> current row in the cursor.
> Like so;
>
> DECLARE
> current table
> --- Original Message ---
> From: Jeff Davis <[EMAIL PROTECTED]>
> To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
> Sent: 14/11/06, 19:05:33
> Subject: Re: [GENERAL] Trouble migrating from PostgreSQL --> Oracle
>
> Use pg_dump if you still
> have problems with PgAdmin, and make sure you're
- Original Message -
From: "Jeff Davis" <[EMAIL PROTECTED]>
To: "Ardian Xharra" <[EMAIL PROTECTED]>
Cc: "postgreSQL postgreSQL"
Sent: Tuesday, November 14, 2006 2:12 PM
Subject: Re: [GENERAL] Data corruption
On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
Hi all,
We have
On Thu, Nov 09, 2006 at 08:54:20AM -0500, Rick Schumeyer wrote:
> To date I have always used pg on a system where I had pg superuser status.
> I'm trying to move a database from such a system to one where I am just
> a user, and I'm having a couple of problems.
>
> The first is, the output of pg_
On Tuesday 14 November 2006 17:34, Alvaro Herrera wrote:
> [EMAIL PROTECTED] wrote:
> > He's just trying to do what you told him.
> > But the use of initdb won't correct the problem Igor got. There's
> > something
> >
> > wrong with his database so that he can't start the postmaster process:
> > >
On Mon, Oct 30, 2006 at 10:49:33PM -0500, Ron Peterson wrote:
> I created a set of PostgreSQL functions which implement the extended set
> of digest/hashing functions provided by the Mhash library
> (http://mhash.sourceforge.net/).
>
> For anyone interested, the code is available here:
>
> http:/
On Tue, 2006-11-14 at 13:34 -0500, Ardian Xharra wrote:
> Hi all,
>
> We have a database installed on Intel Xeon (Dell) and running on
> postgreSQL 8.1.
> And the database couldn't start. Here is the logfile of what happend:
>
> 2006-11-14 00:28:38 PANIC: could not write to log file 6, segment
It depends how you plan to use it?
Maybe a helpful excercise for you to go through is to come up with some
use cases and see if you are storing all the data you'll need in a way
that makes it easy for you to use.
On Tue, 14 Nov 2006, Desmond Coughlan wrote:
X-No-Archive: true
Hi,
Thanks
On Tue, 2006-11-14 at 06:08 -0800, [EMAIL PROTECTED] wrote:
> The software came with scripts to create the owners, tables and
> permissions in Oracle but when using "pgAdmin" (Windows client being
> used to administer the PostgreSQL database at the moment) export
> feature which dumps the entire d
Hi all,
We have a database installed on Intel Xeon (Dell) and running on postgreSQL
8.1.
And the database couldn't start. Here is the logfile of what happend:
2006-11-14 00:28:38 PANIC: could not write to log file 6, segment 239
at offset 6430720, length 16384: Permission denied
2006-11
Christopher Browne wrote:
> Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] ("Nicolas Barbier")
> would write:
> > 2006/10/28, Robert Treat <[EMAIL PROTECTED]>:
> >
> >> On Tuesday 10 October 2006 15:19, stig erikson wrote:
> >>
> >>> Are there any plans to implement CUBE, ROLLUP and/or
X-No-Archive: true Good advice... and no, the 'four tables' was a typo; :) So far, there are only three... I reckon we're not going to split stock into two tables, but your point raises an important question. If I look over my shoulder, say we take Spanish books. There are six or seven co
I have an old server that is still working faithfully. It is running Red
Hat 7.2 and Postgersql 7.2. In anticipation of the day it will die, that
I am concerned is closer than I want it to be, I have set up a shinny
new server running Red Hat Enterprise 4.
I am trying to migrate the database from
Hello.I read the documentation and set all configs like:lc_messages = Portuguese_Brazillc_monetary = Portuguese_Brazil.I installed the support to local language in the folder PostgreSQL\8.1\share\locale\pt_BR.
But I still receiving messages in English. What I missed?Thanks.-- Leodinei Bielak"Civili
I have an 8.1.2 autovac which appears to be hanging/blocking
every few days or so, but we're don't understand what's causing
it. I wasn't able to catch a backtrace before we killed it. I
do not see autovac locks in the pg_locks view.
Will running 8.1.5 buy me anything in terms of being able t
Attached to backend postmaster and got the following. Hope this helps.
Attaching to program: /nfs/silence/bigdisk/eurrow/pgsql/bin/postmaster, process
170422
[Switching to Thread 1]
0x377c in ?? ()
(gdb) break errfinish
Breakpoint 1 at 0x119dc
(gdb) cont
Continuing.
[Switching to
2006/11/14, surabhi.ahuja <[EMAIL PROTECTED]>:
hi
I am trying to download PostgreSQL 8.1.5
however this link does not contain anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/f
Hi There,
I created a cluster with initdb into a custom directory /pgdata/bases, and
ser PGDATA environment to that value. I can start/stop postmaster from
command prompt.
Despite this, when I issue ./postgresql-8.1 start, cluster main is started
up instead.
Hence I modified init-d.functions l
Hi Merlin,
On Tuesday 14 November 2006 17:36, you wrote:
> On 11/13/06, Igor Shevchenko <[EMAIL PROTECTED]> wrote:
> > I've got a problem w/ one of pgsql installations. It can't start:
> >
> > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
> > PANIC: failed to re-find parent key
From: [EMAIL PROTECTED] on
behalf of surabhi.ahujaSent: Fri 11/10/2006 12:03 PMTo:
pgsql-general@postgresql.orgSubject: [GENERAL] how can i prove that
this issue on PG 8.0.0 ERROR: index "patient_pkey" is not a btree is solved in
8.0.9
hi
I am using Postgres 8.0.0 and we found this i
Desmond Coughlan wrote:
X-No-Archive: true
Hi,
Thanks for all the help: we have our postgreSQL server on a 'backend'
machine, and the client on a webserver.
The application I want to develop is a school library, and as this is new to me, I come looking for ideas. Here's what I've
My operating system is Red Hat Linux AS 4, Kerberos 5, with postgresql-7.4.14 that I compiled. I can authenticate using ssh, su, console login, and also have gotten apache mod_auth_kerb to work with AD - but I am missing something with postgresql.When I try:
[EMAIL PROTECTED] ~]$ /usr/loca
Magnus Hagander wrote:
My pg_hba.conf looks like this (with pkoppe01 defined in
Active Directory but not defined in postgres using "createuser")
You need to createuser with the AD username - this allows that user to
connect to PostgreSQL and to own and have various permissions in
PostgreSQL
On 11/13/06, Igor Shevchenko <[EMAIL PROTECTED]> wrote:
Hi All,
I've got a problem w/ one of pgsql installations. It can't start:
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/postgres -D /usr/pgsql/data
PANIC: failed to re-find parent key in "23724"
Aborted
This is PostgreSQL 8.1.5 compiled from sour
He's just trying to do what you told him.
But the use of initdb won't correct the problem Igor got. There's something
wrong with his database so that he can't start the postmaster process:
> PANIC: failed to re-find parent key in "23724"
Unfortunately i don't have any idea how to solve this issue
On Tue, Nov 14, 2006 at 01:58:49PM +0530, surabhi.ahuja wrote:
> hi
> I am using Postgres 8.0.0 and we found this issue "ERROR: index
> "patient_pkey" is not a btree"
> I have been informed that we should shift to Postgres 8.0.9
I beleive you've asked this a few times already. As a rule it alway
On Mon, Nov 13, 2006 at 03:08:18PM -0800, [EMAIL PROTECTED] wrote:
> I just installed a fresh Postgres database. select version(); gives:
>
> "PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
>
> Normal statements like select * from sometable work fine.
Good morning,
I've recently just inherited a PostgreSQL database that is a back end
for some logistics software we use here. We have our own Oracle
servers in our group on faster machines with automated backup so we
would like to move all the data over to Oracle.
The software came with scripts t
I just installed a fresh Postgres database. select version(); gives:
"PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
Normal statements like select * from sometable work fine.
I initiated the default databases, created the postgres user and I
tried to ru
hi
I had Postgres 8.0.0 installed on my m/c
and
now i have installed Postgresql 8.1.4 (FC 4) x86 ,
64 bit arch.
i rebuild my executable giving
-L$(ROOT)/postgres/lib/ -lpq
the directory $(ROOT)/postgres/lib
contains libpq.so with size = 133320
it gives an error (linking error i think),
ho
On Tuesday 14 November 2006 10:52, Enrico wrote:
> Try with:
> > [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Thanks, but this is not working -
[EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
The files belonging to this database system will be owned by user "postg
I just noticed this one:postgres=# select 1000.000::float;
float8
1000(1 row)
postgres=# select 1000.0001::float;
float8---
1000.0001(1 row)
postgres=# select 1000.000100::float;
float8---
1000.0001(1 row)
postgres=#HTH,Best regards,-- [EMAIL PROTECTED][EMAIL PR
Csaba Nagy wrote:
[snip]
I think the idea is to edit the postgresql.conf file on the fly and send
a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to change
Thanks Martijn,
I reduced a number of the buffers and connection settings, and added some more
tracing and this is the result. The number (TopTransactionContext) is smaller,
but still very large. Any reason why this number would suddenly go sky high -
the same system was working fine just a mont
Hello Dimitri,
Cool, thank you.
Even though.. it looks a little... ehm... well optimized? Or shall I say
hard to read? However, it should work for what I want.
Shouldn't such a thing be at least in contrib? How about the reverse,
filling a large object with a bytea value? Admittedly, this is
A. Kretschmer wrote:
am Tue, dem 14.11.2006, um 0:58:56 -0500 mailte Tom Lane folgendes:
"SunWuKung" <[EMAIL PROTECTED]> writes:
Yep, I think this is it:
select trim(trailing '0.' from 1.020)
Um, I think not:
regression=# select trim(trailing '0.' from 1000.000);
rtrim
am Mon, dem 13.11.2006, um 15:08:18 -0800 mailte [EMAIL PROTECTED] folgendes:
> I just installed a fresh Postgres database. select version(); gives:
>
> "PostgreSQL 8.1.5 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
> 3.4.2 (mingw-special)"
>
> Normal statements like select * from sometable
Hello,
Our RPMS (PGDG) require gcj to install. Can we remove that dependency?
Joshua D. Drake
---(end of broadcast)---
TIP 6: explain analyze is your friend
> My operating system is Red Hat Linux AS 4, Kerberos 5, with
> postgresql-7.4.14 that I compiled. I can authenticate using
> ssh, su, console login, and also have gotten apache
> mod_auth_kerb to work with AD - but I am missing something
> with postgresql. When I try:
>
> [EMAIL PROTECTED] ~]
I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
using PostGres 6.5.x (I know I need to upgrade...but that is another
subject...). So far I've done the following:
create function pgpgsql_call_handler() returns opaque as
'/usr/local/pgsql/lib/plpgsql.so' language 'C';
create
"Rob Owen" <[EMAIL PROTECTED]> writes:
> PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
> DBMS was running fine for some months but now one of the databases isn't
> accessible. Any help would be greatly appreciated.
Just one database? Sounds like it might be corrupt da
X-No-Archive: true Hi, Thanks for all the help: we have our postgreSQL server on a 'backend' machine, and the client on a webserver. The application I want to develop is a school library, and as this is new to me, I come looking for ideas. Here's what I've done: on the backend, two users
[EMAIL PROTECTED] wrote:
> He's just trying to do what you told him.
> But the use of initdb won't correct the problem Igor got. There's something
> wrong with his database so that he can't start the postmaster process:
> > PANIC: failed to re-find parent key in "23724"
>
> Unfortunately i don't
surabhi.ahuja wrote:
hi
I am trying to download PostgreSQL 8.1.5
however this link does not contain anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4/
is j
> Thanks, but this is not working -
>
> [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
>
> The database cluster will be initialized with locale C.
>
> in
On Tue, 14 Nov 2006 02:23:39 +0200
Igor Shevchenko <[EMAIL PROTECTED]> wrote:
Try with:
> [EMAIL PROTECTED] ~]$ /usr/pgsql/bin/initdb -D /usr/pgsql/data
Bye Enrico
--
If Bill Gates had a penny for everytime Windows crashed,he'd be a
multi-billionaire by now ...oh look, he already is
[
> I'm confused, what does statement timeout have to do with this? I was
> assuming you would edit "autovacuum = off" to "autovacuum = on" wouldn't
> that work?
Sorry for the confusion, I was thinking about the procedure of changing
programatically the config file and reload it, all this from a
On Tue, Nov 14, 2006 at 07:54:30PM +0530, surabhi.ahuja wrote:
> hi
> I had Postgres 8.0.0 installed on my m/c and
> now i have installed Postgresql 8.1.4 (FC 4) x86 , 64 bit arch.
>
> i rebuild my executable giving -L$(ROOT)/postgres/lib/ -lpq
>
> the directory $(ROOT)/postgres/lib
> contains
On Tue, Nov 14, 2006 at 05:53:08AM -0500, Rob Owen wrote:
> PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
> DBMS was running fine for some months but now one of the databases isn't
> accessible. Any help would be greatly appreciated.
>
> DBMS starts up fine, but any op
On Tue, Nov 14, 2006 at 12:01:44AM +0100, Daniel Verite wrote:
> Also, you'll find this extensively and better explained in this article, for
> example:
> http://ppewww.ph.gla.ac.uk/~flavell/charset/form-i18n.html
This is a *really* good article about character sets and form
submission. Especially
PostgreSQL 8.0.3 running on AIX 5.3 (same thing happens on 5.1 though).
DBMS was running fine for some months but now one of the databases isn't
accessible. Any help would be greatly appreciated.
DBMS starts up fine, but any operation on the files database (psql files,
vaccumdb files, pgdump f
Hi,
Le mardi 14 novembre 2006 14:36, Markus Schiltknecht a écrit :
> I want to convert some large objects to bytea fields on the server.
> Searching through the documentation didn't reveal any hints. Am I
> missing something or is there really no such thing as a
> lo_convert_to_bytea function?
Yo
Hi,
I want to convert some large objects to bytea fields on the server.
Searching through the documentation didn't reveal any hints. Am I
missing something or is there really no such thing as a
lo_convert_to_bytea function?
Regards
Markus
---(end of broadcast)--
[snip]
> I think the idea is to edit the postgresql.conf file on the fly and send
> a SIGHUP to the postmaster. I haven't ever heard of anyone doing that,
> but I don't see any reason why it wouldn't work.
It works, I did it for a while with the statement_timeout to change it
globally over night
hi
I am trying to download PostgreSQL
8.1.5
however this link does not contain
anything:
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4-x86_64/
moreover the link
http://www.postgresql.org/ftp/binary/v8.1.5/linux/rpms/fedora/fedora-core-4/
is just containing the dri
On Mon, Nov 13, 2006 at 01:26:08PM -0800, Kojak wrote:
> I'm trying to install PL/pgSQL so that I can use it in a FUNCTION. I'm
> using PostGres 6.5.x (I know I need to upgrade...but that is another
> subject...).
No, you need to upgrade first. 6.5 is positivly prehistoric, no-one is
going to be
X-No-Archive: true That's exactly what it was, thanks! 7.4 installed now, and I have ¨PhP support!! D.Walter Vaughan <[EMAIL PROTECTED]> a écrit : Desmond Coughlan wrote:> Hi. As title. I'm getting a host of syntax errors, the last ten lines > of which are ...> > NV_READ' undeclared (firs
100 matches
Mail list logo
