> Without including libpq.lib in (project->
> properties->Linker->Input->Additional dependencies ) I just
> started learning to work on MFC/.Net Please suggest me how to proceed
>
> webs error LNK2019: unresolved external symbol _PQfinish
> referenced in function [EMAIL PROTECTED] webs error L
Hello to all ...
I'm trying to install a backup system for my Postgresql 8.1.1 (on windows xp)
using 3 wal files.
So i change these parameters in postgresql.conf
checkpoint_segments = 3
archive_command = 'copy "%p" "D:/PostgreSQL/backup/%f"'
I stop the database service and then restart it ...
B
Hi,
On Tue, 2005-12-13 at 13:59 -0500, Chris Hoover wrote:
> However, when I run initdb --locale=C -D / I get the following:
> [EMAIL PROTECTED] bin]$ initdb --locale=C -D /postgresql/50001/
> creating configuration files ... ok
> creating template1 database in /postgresql/50001/base/1 ... child
hi Magnus.
Thank you verymuch.Problem is solved
It is because of "Debug Mulithread ed using DLL" only.
-Sandhya
- Original Message -
From: "Magnus Hagander" <[EMAIL PROTECTED]>
To: "sandhya" <[EMAIL PROTECTED]>; "postgre"
Sent: Wednesday, December 14, 2005 2:41 PM
Subject: Re:
Hi,
I want to have postgresql.conf and pg_hba.conf outside the directory
created by initDB.
$PGDATA points to the directory the config files reside in (and nothing
else) and in postgresql.conf the option "data_directory" is set to the
directory containing the cluster created by initDB. I can
On 12/14/05, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> AFAIR, this is a result of lack of system resources, like semaphores,
> etc. Can you see any clues in /var/log/pgsql/pgstartup.log ?
>
> Regards,
> --
> The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
> PostgreSQL Replication, Co
Hi,
On Wed, 14 Dec 2005, Chris Hoover wrote:
On my 8.1.1 box I get:
[EMAIL PROTECTED] ~]$ /usr/bin/postgres -V
Hmm. Two questions:
- Is SELinux enabled?
- What is the output of
rpm -qa|grep postgresql
BTW... I've uploaded a new series of RHEL AS 4 RPMs yesterday to FTP
server. I'm
Hannes Dorbath <[EMAIL PROTECTED]> writes:
> I want to have postgresql.conf and pg_hba.conf outside the directory
> created by initDB.
> $PGDATA points to the directory the config files reside in (and nothing
> else) and in postgresql.conf the option "data_directory" is set to the
> directory c
Devrim GUNDUZ <[EMAIL PROTECTED]> writes:
> On Wed, 14 Dec 2005, Chris Hoover wrote:
>> On my 8.1.1 box I get:
>> [EMAIL PROTECTED] ~]$ /usr/bin/postgres -V
> Hmm. Two questions:
> - Is SELinux enabled?
I think that's the only question you need ;-). And the answer is
probably "get a newer versio
Hi,
On Wed, 2005-12-14 at 10:42 -0500, Tom Lane wrote:
> > Hmm. Two questions:
> > - Is SELinux enabled?
>
> I think that's the only question you need ;-). And the answer is
> probably "get a newer version of selinux-policy". Disallowing the
> postgres executable from writing on /dev/tty was on
Hi all,I need to use PITR for to do backup in a critical enviroment, but this configuration save the segment files in the backup directory only when the segment file (in pg_xlog) is full, ¿Is there any way to configure the WAL like a real online backup?
In my enviroment is necesary the 0% data lost
On 12/14/05, Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> On Wed, 14 Dec 2005, Chris Hoover wrote:
>
> > On my 8.1.1 box I get:
> > [EMAIL PROTECTED] ~]$ /usr/bin/postgres -V
>
> Hmm. Two questions:
> - Is SELinux enabled?
> - What is the output of
> rpm -qa|grep postgresql
>
> BTW
Hi,
On Wed, 2005-12-14 at 11:12 -0500, Chris Hoover wrote:
> Also, would it be possible for the initdb to mention that as a
> possible problem when if fails? It would be very helpful since there
> was not any real help from initdb on where to look for the problem.
This is not a PostgreSQL (and
On Wed, Dec 14, 2005 at 17:54:53 +0200,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
> Hi,
>
> On Wed, 2005-12-14 at 10:42 -0500, Tom Lane wrote:
> > > Hmm. Two questions:
> > > - Is SELinux enabled?
> >
> > I think that's the only question you need ;-). And the answer is
> > probably "get a newer
I just installed postgres 8.1.1 on a dual optron Linux box running Linux
4 advanced server, with 32GB of RAM and 2GB of swap.
I'm trying to allocate 24 GB as shared_bufferes. I'm getting an error
that I can not allocate memory (see below). If I change my
shared_buffers to 16GB, postgres starts up
"Tomeh, Husam" <[EMAIL PROTECTED]> writes:
> I just installed postgres 8.1.1 on a dual optron Linux box running Linux
> 4 advanced server, with 32GB of RAM and 2GB of swap.
> I'm trying to allocate 24 GB as shared_bufferes. I'm getting an error
> that I can not allocate memory (see below).
While t
You're correct on trying and figuring the appropriate value of
shared_buffers for our application which I'd be doing. However, I wanted
to test how far I can get specially that 8.1 removed the limit of 2GB on
a 64-bit architecture like ours. The other thought is that my assumption
(which I may be
I was trying to run a bulk data load using the COPY command on PGSQL 8.1.0.
After loading about 3,500,000 records it ran out of memory - I am
assuming because it ran out of space to store such a large transaction.
Does the COPY command offer a similar feature to Oracle's SQL*Loader
where you c
Not sure if the kernel shared memory segment size is appropriate, you are
allocating all your memory to the chunk.
With 32GB memory, effective_cache_size can be raised, higher, and you can go
down on shared_buffers. Check this:
http://www.varlena.com/varlena/GeneralBits/Tidbits/annotated_conf_e
unsubscribe pgsql-admin
Hi,I have installed Suse Linux Opeb Excchange server and its running using postgresql-7.2.2-35. And my problem here is i cant log in to the database itself using command pgsql < db name > . Is there another command to log in to the database ?I hope somebody will help me on this problem . And also p
Kevin Keith <[EMAIL PROTECTED]> writes:
> I was trying to run a bulk data load using the COPY command on PGSQL 8.1.0.
> After loading about 3,500,000 records it ran out of memory - I am
> assuming because it ran out of space to store such a large transaction.
COPY per se shouldn't eat memory.
P
hi Magnus
It compiled and Linked properly after mentioning "Debug Multithread ed using
DLL"But i faced problem while executing it
Simply i gave in Configuration properties-> Linker->Input-> ignore library
the library name "LIBCMTD.lib"
Then it worked fine...
Any thing wrong in this?
Ju
24 matches
Mail list logo
