While creating roles using PgAdmin, there is a check box stating "Inherits
rights from parent roles" if you do not check that option that implicitly means
you need NOINHERIT. If you create a role using CL, and do not mention anything,
then INHERIT is the default option.
Subject: Re: [ADMIN] p
Hi there,
sorry if this is the wrong group. The problem is that the software in use is
not capable of using UTF-8 as encoding yet. So LATIN1 has been used as server
and database encoding for Linux and Windows. However, as PostgreSQL 8.3 is
enforcing matching encodings and locales it's not possi
Hello!
My filesystem (UFS-FreeBSD) was crashed and I have lost files from
PGSQL DATA DIR FOLDER after fsck-utility.
I have lost files from directory "pg_xlog"
I reset my pg_xlog.
And now have such error by starting pgsql-server:
LOG: database system was interrupted at 2008-03-18 22:29:48 EET
L
Στις Wednesday 19 March 2008 16:56:19 ο/η veejar έγραψε:
> Hello!
>
> My filesystem (UFS-FreeBSD) was crashed and I have lost files from
> PGSQL DATA DIR FOLDER after fsck-utility.
>
> I have lost files from directory "pg_xlog"
> I reset my pg_xlog.
>
> And now have such error by starting pgsql-
I noticed that there is not a 64 bit windows version of postgres
binaries. When will the 64 bit version be available?
Thanks,
Lance Campbell
Project Manager/Software Architect
Web Services at Public Affairs
University of Illinois
217.333.0382
http://webservices.uiuc.edu
I¹m attempting to do something that should be a trivially simple task. I
want to do a data only dump from my production data in the public schema and
restore it on another machine. Both machines are running 8.2.5, both
machines are virtually identical and have 16GB of RAM.
I created an archive w
I just read the following article:
http://people.planetpostgresql.org/mha/index.php?/archives/162-PostgreSQ
L-vs-64-bit-windows.html
Would there be benefits in running PostgreSQL in a 32 bit mode on a 64
bit version of XP? My thought is that the OS could access more of the
memory for the
Aaron Brown <[EMAIL PROTECTED]> writes:
> I¹m attempting to do something that should be a trivially simple task. I
> want to do a data only dump from my production data in the public schema and
> restore it on another machine.
Does it really need to be data-only? A regular schema+data dump usual
Yes, it kind of needs to be data only since I am pulling from a slonized
database. My experience has been if you don¹t load the schema first with a
schema from slony1_extract_schema.sh, we end up with all the slony triggers
and crap in the dump. If there is a better way of doing this, I¹m
definit
Aaron Brown <[EMAIL PROTECTED]> writes:
> Yes, it kind of needs to be data only since I am pulling from a slonized
> database. My experience has been if you don¹t load the schema first with a
> schema from slony1_extract_schema.sh, we end up with all the slony triggers
> and crap in the dump. If
I agree that they ³should². Unfortunately, nothing about slony is simple,
in my experience.
On 3/19/08 3:17 PM, "Tom Lane" <[EMAIL PROTECTED]> wrote:
> Aaron Brown <[EMAIL PROTECTED]> writes:
>> > Yes, it kind of needs to be data only since I am pulling from a slonized
>> > database. My exper
Hello,
I'm having what I consider a strange problem, although it may be
caused by my being such a newby to Postgres. I have been asked to
send a empty database to a colleague by a researcher. The first time
I created it, I didn't realize they want it empty. I created the
database and t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wed, 19 Mar 2008 17:21:39 -0400
Carol Walter <[EMAIL PROTECTED]> wrote:
The tables were there and populated. I've
> even made sure the database was dropped by listing the databases.
> Still, when I recreate it, it comes with all the tables there
Carol Walter <[EMAIL PROTECTED]> writes:
> ... Why does this come back
> with all the tables intact when I drop it and recreate a database
> with the same name?
Most likely, you accidentally created all that stuff in template1,
and CREATE DATABASE is just copying it from there. Clean out temp
I'm a novice & I'm trying to start posgtres by doing /etc/init.d/postgresql
start.
It starts.
But the next min if i try to check the process by doing ps -auwx | grep post, I
dont see any process.
My installation is in /var/lib/pgsql/data.
There is nothing in serverlog.
What can be the reason?
I'm a novice & I'm trying to start posgtres by doing /etc/init.d/postgresql
start.
It starts.
But the next min if i try to check the process by doing ps -auwx | grep post, I
dont see any process.
My installation is in /var/lib/pgsql/data.
There is nothing in serverlog.
What can be the rea
Hi,
On Thu, 2008-03-20 at 10:07 +0530, smp wrote:
>
> There is nothing in serverlog.
>
> What can be the reason?
Check /var/lib/pgsql/pgstartup.log , if it exists.
Regards,
--
Devrim GÜNDÜZ , RHCE
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared an
i get message as below
FATAL: database files are incompatible with server
DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 71, but
the server was compiled with PG_CONTROL_VERSION 812.
HINT: It looks like you need to initdb.
- Original Message
From: Devrim GÜNDÜ
Hi,
On Thu, 2008-03-20 at 10:54 +0530, smp wrote:
> FATAL: database files are incompatible with server
> DETAIL: The database cluster was initialized with PG_CONTROL_VERSION
> 71, but the server was compiled with PG_CONTROL_VERSION 812.
> HINT: It looks like you need to initdb.
You have an ol
Hi
We will be setting up a production postgres database to which an
application will connect through a firewall. Can any one please tell me
if there is any configuration that needs to be done on the postgres
database side for firewall. Is there any documentation that I can refer
to. Any help wil
20 matches
Mail list logo
