Installation of 7.4.2, even with just ./configure : gmake step ==
_
gmake[4]: Leaving directory
`/usr/home/smith/Temp_holding/staging-area/postgresql/postgresql-7.4.2/src/backend/parser'
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
Can a database system be restored just from the data under the
installation directory?
I backed-up my database using rsync /var/lib/pgsql dest_directory
Then I upgraded my rpms from 7.3.4 to 7.4. Then I tried to start the
server as usual and it complained about version conflict (of course).
I
Hi,
we are running the CanIt mailscanner on some machine. (See
http://www.canit.ca .) This application is based on postgresql.
However, we frequently observe the following message in the log files:
PGRES\_FATAL_ERROR : ERROR: out of free buffers: time to abort!
Any hints what's going on?
Tom, David,
thanks for the hints. Following you, I have upgraded to 7.3.4 (the last
version for which an RPM by Red Hat is provided) and the problem seems
gone now.
Regards,
Jochen
On Fr, 2004-06-18 at 17:22, Tom Lane wrote:
David F. Skoll [EMAIL PROTECTED] writes:
Hi, Jochen.
However,
Hi all,
When I try to run 'initdb' in a cygwin environment, I got this output:
$ /usr/local/postgresql7.4.1/bin/initdb -d -D
/usr/local/postgresql7.4.1/data
Running in debug mode.
initdb: internal variables:
PGDATA=/usr/local/postgresql7.4.1/data
datadir=/usr/local/postgresql7.4.1/share
I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want to reconfigure and reinstall. How do I
know what, where all
Attempting a FreeBSD install of 7.4.3, apparently remnants of 7.3.x are
scattered around on the disk from (a) previous ports installation,
causing mutex_lock/unlock, libpq.so and other installation problems. How
do I know what, where all these fragments are located or how do I
uninstall all
Hi
folks!
I
would like to know if there is someway to
interface mssqlserver
with pgsql such that
sqlserver can understand
the pgsql encoding.
Thanx
a lot!
\\\!/ 55 11 5080
9258
!_"""_! Elielson
Fontanezi
(O) (o)
PRODAMoOOO--(_)--OOOo---
Hello,
I am using krb5 authorization and have a problem with the mangling of krb5
principal names. E.g. on authentication, the principals 'foo/[EMAIL PROTECTED]'
and 'foo/[EMAIL PROTECTED]' will be both rewritten to the local username 'foo',
which is completely unwanted and might be a security
On Thu, 2004-06-17 at 09:57, C. Bensend wrote:
The problem here isn't pg_autovacuum, but too small of settings for
fsm. I've run multi-day tests where autovacuum kept the size of the
database pretty much the same with 200+ updates a second going on.
Hi Scott,
Could you explain the
BTW: Forgot to mention FreeBSD 4.9 O?S
Adam Smith wrote:
Installation of 7.4.2, even with just ./configure : gmake step ==
_
gmake[4]: Leaving directory
`/usr/home/smith/Temp_holding/staging-area/postgresql/postgresql-7.4.2/src/backend/parser'
gcc
Dear Sir:
After complied my postgresql-7.4.2 with
the RH-linux9 operation system,
there showed a problem on my
configure.log as the file below with bold type word,
.
.
.
configure: failed program was:#ifndef
__cplusplus choke me#endif.
.
.
configure: failed program was:#line 2642
Hi all,
I install cygwin in my windows2000 so as to install postgresql. When I
use the postgresql installed together with cygwin, I came into this problem:
First, I run
ipc-daemon2
Second, when I try to initialize the database by running the following
command,
initdb -D
Hi,
I use PG 7.4 and adoDB library with PHP to develop. Recently I noticed
errors were being logged in my /var/log/messages for Postgresql
errors, however, my transactions were not bombing out as expected.
A simple example:
$sql = SELECT my_pgsql_function($x,$y);
$db-BeginTrans();
Title: Missing or erroneus pg_hba.conf file
Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a connection from my PC to the server, using pgAdminIII, I get the message above. This is my pg_hba.conf file:
local all all trust
# IPv4-style local connections:
Hi,
We are trying to install PostgreSql-7.4.2 on HPUX 11.23i. after installation
initdb fails with the following error message.
dome % ./bin/initdb -D /xxx/postgresql-7.4.2/data
./bin/initdb[127]: 1588 Killed
./bin/initdb[131]: 1589 Killed
./bin/initdb[136]: 1590 Killed
The program
DEBUG5 is not enough to log SQL statements
--
I've set up a courier-imap POP server authenticating against a
PostgreSQL table through authdaemond/authpgsqlrc. I can verify
courier-imap sends its SELECT statement to make a login attempt but
the POP login
Harry wrote:
creating template1 database in
/usr/local/postgresql7.4.1/data/base/1... DEBUG:
invoking IpcMemoryCreate(size=1081344)
FATAL: could not create shared memory segment: Function not
implemented DETAIL: Failed system call was shmget(key=1,
size=1081344, 03600). DEBUG:
frank wrote:
Dear Sir:
After complied my postgresql-7.4.2 with the RH-linux9 operation
system,
there showed a problem on my configure.log as the file below with
bold type word, .
.
.
configure: failed program was:
#ifndef __cplusplus
choke me
#endif
As long as PostgreSQL compiles
Sandro Ribeiro - Claro RS - [EMAIL PROTECTED] wrote:
Hello!
My server is working with pgsql 7.4.2 and Unix Solaris 8. Well, when a try a
connection from my PC to the server, using pgAdminIII, I get the message
above. This is my pg_hba.conf file:
local all all
[EMAIL PROTECTED] (Reto) writes:
I've run postmaster with the highest
possible debug level but the SQL statements are not being logged yet
You need to turn on log_statement ...
regards, tom lane
---(end of broadcast)---
Sandro Ribeiro - Claro RS - [EMAIL PROTECTED] writes:
My server is working with pgsql 7.4.2 and Unix Solaris 8.
[ this pg_hba.conf line doesn't work: ]
hostall all 127.0.0.1 255.255.255.255 trust
We've seen some reports suggesting that Solaris has a problem with
On Fri, Jun 18, 2004 at 16:42:18 -0700,
Chris Fjell [EMAIL PROTECTED] wrote:
Can a database system be restored just from the data under the
installation directory?
Only if the postmaster has been shut down. For live backups you should
be using pg_dumpall.
---(end of
Hello,
Do you know a good postgresql database schema generator ?
Does not have to be free or open source.
Thanks !!!
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
Hi,
I am trying install the postgresql-7.4.3 simple
installation. I did ./configure command at the postgresql directory source.
While the configuring proccess I receiving the follow message:
checking for tar... /bin/tarchecking for
strip... stripchecking whether it is possible to strip
Dear Janio ,
checking for a BSD-compatible install... /usr/bin/ginstall -c
checking whether build environment is sane... configure: error: newly
created file is older than distributed files!
Check your system clock
Check your system clock check this
Or your bison tarball is older than the
On Sun, 2004-06-20 at 11:27 -0400, Frederic Medery wrote:
Hello,
Do you know a good postgresql database schema generator ?
dia+tedia2sql
google for URLs
--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro
---(end of
There is some information on www.varlena.com I think it may have been Scott
who wrote the article that I'm thinking about. There is other information
about, your best bet may be google.
Regards
Iain
- Original Message -
From: C. Bensend [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being led to believe that this then 'Must be a
stupid question' although people say that there is no stupid question.
Is that another for political correctness
I am attempting an install of 7.4.3
Do you know how it was originally installed? RPM or compiled source?
Are you also transferring data from 7.3 to 7.4?
Mike
RPM can be
On Sun, 2004-06-20 at 21:50, Adam Smith wrote:
I have posted this and similar questions repeatedly and can't even raise
a single response. I am being
On Sun, Jun 20, 2004 at 07:50:53PM -0700, Adam Smith wrote:
I am attempting an install of 7.4.3 on FreeBSD O/S 4.9, apparently
remnants of 7.3.x are scattered around on the disk from (a) previous
ports installation, causing mutex_lock/unlock, libpq.so and other
installation problems. I want
31 matches
Mail list logo