Is Postgresql-XC being used far-and-wide in production? It looks like an
attractive path for a problem I'm considering, that problem being close to zero
downtime with data replicated to all the datanodes. I suspect that is not the
primary purpose of the effort, rather to partition across the n
On May 3, 2013, at 9:45 AM, Nghia Truong wrote:
> Hi everyone,
> Every day, the file pg_hba.conf in my server is rewritten and postgresql
> received a SIGHUP to reload configuration.
Sounds like some sysadmin scripted rsync gone wild.
On Apr 6, 2013, at 12:46 PM, Jim Mercer wrote:
>
> can someone provide a walk-through of using these functions both for
> a backup and a restore?
http://www.postgresql.org/docs/9.2/interactive/continuous-archiving.html#BACKUP-PITR-RECOVERY
24.3. Continuous Archiving and Point-in-Time Recovery
On Jan 17, 2013, at 11:20 AM, Scott Whitney wrote:
> What I want to know is whether there's a situation in which my standby is
> running, the receiver process is running, but "something" is wrong.
I compare pg_controldata output from the two clusters periodically.
On Dec 20, 2012, at 10:22 AM, Gary Stainburn wrote:
> On Thursday 20 December 2012 14:57:31 Ray Stell wrote:
>> createrole is really hard to find when you search for "create role."
>> Thanks.
>
> I always prefix any google search with 'postgresql'
On Dec 20, 2012, at 9:45 AM, Lou Picciano wrote:
> To get what you need, though, the 'db user' simply needs the CREATEROLE
> privilege set.
>
createrole is really hard to find when you search for "create role." Thanks.
I have a app where the install guide says to give a db user the ability to
create roles.
"Ensure that the user has permission to create database objects and can create
roles."
How is that done...elegantly? Seems like the oracle idea of a role.
--
Sent via pgsql-admin mailing list (pgsql-adm
On Sep 11, 2012, at 8:10 PM, Wells Oliver wrote:
> So, now I have 16GB of WAL segments, 974 of them. Will postgresql clean this
> up? Will it remove these files? Will it create more with big inserts?
>
> What is the best way to manage this?
http://www.postgresql.org/docs/9.2/static/pgarchivecl
On Sat, Jun 23, 2012 at 07:01:08AM -0500, Mike Broers wrote:
> Hello,
>
> We shut down our postgres 8.3 server last night cleanly for some hosted
> services maintenance. When we got our server back, it didnt have the
> pg_xlog mount with files
what happened to make the files not available? Seem
On Wed, Mar 07, 2012 at 05:41:41PM +, Walter Hurry wrote:
> On Wed, 07 Mar 2012 10:39:48 -0500, Ray Stell wrote:
>
> misc=# create table test1(flag varchar(1));
> CREATE TABLE
> misc=# create table "test1 "(flag varchar(1));
> CREATE TABLE
yeah, that is the case
how I can differentiate these:
oamp=# \z public.c3*
Access privileges
Schema | Name | Type | Access privileges | Column access
privileges
+---+---+---+--
public | c3p0_c
On Sat, Mar 03, 2012 at 08:27:19PM +0200, Peter Eisentraut wrote:
> On ons, 2012-02-29 at 16:25 -0500, Ray Stell wrote:
> > On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> > > http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> > > Th
On Wed, Feb 29, 2012 at 03:55:13PM -0500, Ray Stell wrote:
> http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
> This must be repeated in each
> database to be fixed.
including postgres, template0, and template1?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresq
on rebuilding the information_schema:
http://www.postgresql.org/docs/9.1/static/release-9-1-2.html
...
Since the view definition is installed by initdb, merely upgrading will
not fix the problem. If you need to fix this in an existing installation,
you can (as a superuser) drop the information_sche
On Sun, Dec 18, 2011 at 03:57:54PM +, Khusro Jaleel wrote:
> On 16/12/2011 00:55, Rural Hunter wrote:
>
> You are referring to the "master" log file, is this the same log file I am
> referring to, or is that is some different location?
http://www.postgresql.org/docs/9.1/interactive/runtime-co
On Sun, Oct 16, 2011 at 08:21:31PM +0100, Simon Riggs wrote:
> On Fri, Oct 14, 2011 at 3:02 PM, Ray Stell wrote:
>
> > The tutorial here excludes an important issue:
> > http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby
> > After the
The tutorial here excludes an important issue:
http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Failing_Over_To_The_Standby
After the failover is complete, it seems like a restart is required to
make the new primary capable of supporting a new hot standby. Can the
config values be chang
On Sun, Oct 09, 2011 at 10:49:28AM +0200, Lukasz Brodziak wrote:
> Hi,
> I would go with cluster on the relation with invalid page header and try to
forgive me, what does "cluster on the relation" mean?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
On Sun, Sep 18, 2011 at 10:47:39AM +0800, Rural Hunter wrote:
> Any suggestion?
I don't do ubuntu this week, so I may be out to lunch, but
why don't you append to the system set value of the var.
In RH (this week) we do this in /etc/profile.d/localpath.sh
but shirley ubuntu has some means for doin
On Wed, Jul 06, 2011 at 07:34:11PM +0530, Jahnavi Chintakunta wrote:
>
>
> When the standy server is stopped, then the pg_xlog's in the master server
> are stagnant.
Sorry, I've never seen this before.
What is archive_timeout set to?
template1=# show archive_timeout;
archive_timeout
On Wed, Jul 06, 2011 at 03:02:22PM +0530, Jahnavi Chintakunta wrote:
>
> But these files are getting copied continuously and they are not stopping.
>
> Master is generating pg_xlog files even when there is no activity on the
> database.
How did you determine there was no activity? Have you que
On Tue, Jun 07, 2011 at 11:59:07AM -0700, A J wrote:
> We then rely on filesystem tools (or other third party tools) to get the
> original master in sync with the new master efficiently and then make it join
> as
> slave.
the doc would not be corrupted by an additional few words that stated as
On Tue, Jun 07, 2011 at 09:32:31AM -0700, A J wrote:
> Hello,
> I am trying to switch the master and slave roles in a test I am doing with
> streaming replication in 9.1 beta.
>
http://www.postgresql.org/docs/9.1/static/warm-standby-failover.html
Once failover to the standby occurs, there is on
On Sat, Jun 04, 2011 at 10:05:46AM +0900, ?? wrote:
>
> ERROR: odbclink: unsuccessful SQLConnect call: [S1000] [12514]
>
> [[unixODBC][Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently
> know of service requested in connect descripto
>
$ oerr ora 12514
12514, 0, "TNS:liste
On Wed, Jun 01, 2011 at 04:56:12PM +, Campbell, Lance wrote:
> Postgresql: 8.4.x
> How do you add a timestamp to the logs. Currently I see:
>
> ERROR: {some error message}
> STATEMENT: {the sql statement}
>
> Ideally I would like to have the timestamp in front of the statements.
>
> Thanks,
On Wed, Jun 01, 2011 at 06:47:51AM -0400, Greg Smith wrote:
> Ray Stell wrote:
>> I want to do OS patching on prod and hot standby. What is the advised
>> procedure for maintenance on the two systems? I would think patching
>> the standby should come first in case it blows
I want to do OS patching on prod and hot standby. What is the advised
procedure for maintenance on the two systems? I would think patching
the standby should come first in case it blows something up. Oracle has
a defer switch you can throw on prod to tell it to relax on log shipping
to the standb
On Wed, Apr 27, 2011 at 01:29:10PM -0700, ramon cruel wrote:
> Please!!!
http://mail.postgresql.org/mj/mj_wwwusr/domain=postgresql.org?func=lists-long-full&extra=pgsql-admin
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgre
On Tue, Apr 19, 2011 at 11:16:08AM +0200, rudi wrote:
> On 04/19/2011 10:09 AM, Gerhard Hintermayer wrote:
> So you keep the old pg_xlog
the admin book says to exclude old pg_xlog
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.
On Fri, Apr 15, 2011 at 08:52:24AM +0100, Simon Riggs wrote:
> On Fri, Apr 15, 2011 at 2:25 AM, Ray Stell wrote:
>
> > The cookbook text says, log shipping "is mostly superseded by streaming
> > replication in 9.0, though is still useful as part of a comprehensive
>
The cookbook text says, log shipping "is mostly superseded by streaming
replication in 9.0, though is still useful as part of a comprehensive
backup strategy." The implication is that the WAL archive might be
needed for recovery in some cases:
1. Under what circumstances might the WAL archive com
On Wed, Feb 09, 2011 at 09:28:18AM -0500, Ray Stell wrote:
> On Wed, Feb 09, 2011 at 08:55:48AM -0500, Ray Stell wrote:
> my bad, this was a path issue, I was using a v8 pg_controldata cmd.
> the v9 pg_controldata looks good. Sorry.
Come to think about it, could the pg_controldata
On Wed, Feb 09, 2011 at 08:55:48AM -0500, Ray Stell wrote:
> I had set up this streaming replication pair of systems a few days ago and
> everything seemed pretty happy as changes were being replicated. I set
> it up without wal archiving turned up. The backup log this morning caught
I had set up this streaming replication pair of systems a few days ago and
everything seemed pretty happy as changes were being replicated. I set
it up without wal archiving turned up. The backup log this morning caught
my eye. I find the standby reports to have activated itself.
I don't see a
On Wed, Feb 02, 2011 at 06:32:22PM -0500, Tom Lane wrote:
> Ray Stell writes:
> > Streaming replication standby moved from 9.0.2->9.0.3 logs this up
> > startup:
>
> > database system was shut down in recovery at 2011-02-02 15:28:51 EST
> > entering standby mo
Streaming replication standby moved from 9.0.2->9.0.3 logs this up
startup:
database system was shut down in recovery at 2011-02-02 15:28:51 EST
entering standby mode
redo starts at 0/65000170
consistent recovery state reached at 0/6600
unexpected pageaddr 0/6200 in log file 0, segme
On Wed, Dec 01, 2010 at 09:54:11AM -0600, Kevin Grittner wrote:
> "Lello, Nick" wrote:
>
> > What is considered the best filesystem to use for postgres data
> > stores ?
>
Greg dedicates a chapter in his book on the topic:
https://www.packtpub.com/postgresql-9-0-high-performance/book
--
Sen
On Mon, Nov 01, 2010 at 12:46:33PM -0400, Tom Lane wrote:
> Ray Stell writes:
> > Someone asked about ssl client cert auth recently. I got
> > this to work, but something tripped me up.
>
> > http://developer.postgresql.org/pgdocs/postgres/ssl-tcp.html
>
> >
Someone asked about ssl client cert auth recently. I got
this to work, but something tripped me up.
http://developer.postgresql.org/pgdocs/postgres/ssl-tcp.html
states (very clearly, btw) that, "To require the client to supply a
trusted certificate, place certificates of the certificate authorit
On Thu, May 27, 2010 at 12:49:49PM -0400, Tom Lane wrote:
> alvherre writes:
> > Excerpts from Ray Stell's message of mi?? may 26 17:08:33 -0400 2010:
> >> I just installed a compiled from src 8.3.11. I usually include %i,
> >> command tag,
> >> in the log_line_prefix setting. This causes some
I just installed a compiled from src 8.3.11. I usually include %i, command tag,
in the log_line_prefix setting. This causes some spewage I'd not seen before
on connection received lines as if it is dumping the environment:
[unknown],17462,[unknown],2010-05-26 16:04:33.293
EDT,4bfd7ed1.4436,1,20
On Wed, May 19, 2010 at 08:40:04AM +0300, Mikko Partio wrote:
>
> May 16 01:17:35 xxx postgres[25550]: [1-1] LOG: could not truncate
> directory "pg_subtrans": apparent wraparound
>
http://archives.postgresql.org/pgsql-general/2007-06/msg01050.php
--
Sent via pgsql-admin mailing list (pgsql-a
On Thu, May 13, 2010 at 09:31:27AM -0500, Kevin Grittner wrote:
> Ray Stell wrote:
> > ,3440,,2010-05-13 09:06:35.734 EDT,4bebf95b.d70,5,2010-05-13
> > 09:06:35 EDT,0,FATAL: could not restore file "0002.history"
> > from archive: return code 32512
>
>
On Tue, May 11, 2010 at 04:29:18PM +0300, Devrim G?ND?Z wrote:
> On Tue, 2010-05-11 at 09:16 -0400, Ray Stell wrote:
> > What are the steps for upgrade of a primary/PITR standby pair to the
> > latest 8.3 patchset, 8.3.6-8.3.10? I don't see this in the docs.
> > Shoul
What are the steps for upgrade of a primary/PITR standby pair to the
latest 8.3 patchset, 8.3.6-8.3.10? I don't see this in the docs.
Should there be something added to 15.4. Upgrading?
My guess is:
1. turn off the standby config in primary
2. upgrade primary
3. rebuild standby
That way you
On Mon, Apr 12, 2010 at 08:42:32AM -0500, Kevin Grittner wrote:
> Dennis Thrys?e wrote:
>
> > Are there any good tools or logging options for determining
> > who/what?
maybe turn off the port while you are in maintenance mode?
tcpdump should show you the host in question.
--
Sent via pgsql-adm
On Fri, Apr 09, 2010 at 10:19:20AM +0200, Dennis Thrys?e wrote:
> "cp: cannot stat `/psql_archive/0001.history': No such file or directory"
>
> By the way, one of these lines each second!
>
> "2010-04-09 09:09:49 IST FATAL: the database system is starting up"
I asked about this a few weeks
On Wed, Mar 24, 2010 at 01:10:31PM -0400, Ray Stell wrote:
> 2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp
> /home/postgresql/fms/wals/%f %p"
>cp: cannot stat `/home/postgresql/fms/wals/0001.history': No such file
> or directory
patience, yo
While testing an 8.2.15 pitr procedure I see this postmaster log entry on
startup of the
recovered cluster:
2010-03-24 12:38:36.357 EDT,,3,,, LOG: restore_command = "cp
/home/postgresql/fms/wals/%f %p"
cp: cannot stat `/home/postgresql/fms/wals/0001.history': No such file
or directory
On Tue, Feb 09, 2010 at 05:39:52PM -0500, Ray Stell wrote:
> On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote:
>
> Is autovacuum handing all users off to vacuum all rels? Even those
> it does not own? Perhaps "admin" an unfortunate usename choice?
doh...the li
On Sat, Jan 30, 2010 at 09:59:36AM -0500, Ray Stell wrote:
> Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> other pg_ tables:
>
> VACUUM WARNING: skipping "pg_database" --- only table or database owner can
> vacuum it
More logging shows th
On Sat, Jan 30, 2010 at 07:18:52PM -0700, Scott Marlowe wrote:
> On Sat, Jan 30, 2010 at 7:00 PM, Ray Stell wrote:
> > On Sat, Jan 30, 2010 at 10:35:27PM -0300, Alvaro Herrera wrote:
> >> Ray Stell wrote:
> >> > Running 8.2.15 on RHEL4 the log reports this from auto
On Sat, Jan 30, 2010 at 10:35:27PM -0300, Alvaro Herrera wrote:
> Ray Stell wrote:
> > Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> > other pg_ tables:
> >
> > VACUUM WARNING: skipping "pg_database" --- only table or datab
On Sat, Jan 30, 2010 at 10:28:37AM -0700, Scott Marlowe wrote:
> On Sat, Jan 30, 2010 at 7:59 AM, Ray Stell wrote:
> > Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
> > other pg_ tables:
> Make yourself the owner of the database? (i.e. alter database ..
Running 8.2.15 on RHEL4 the log reports this from autovacuum along with
other pg_ tables:
VACUUM WARNING: skipping "pg_database" --- only table or database owner can
vacuum it
Any ideas how I can clean this up or how I got into this hole?
Vacuum works as superuser.
Thanks.
--
Sent via pgs
On Wed, Jan 20, 2010 at 10:10:26AM -0500, David F. Skoll wrote:
> The machine had bad RAM; we were getting undetected/uncorrected single-bit
> errors creeping through!
who's the machine/memory vendor?
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
Do people use "gp_ctl stop -m i" in production? I've had some difficulty
with the apps admin getting all the clients shut during maintenance
windows. I'm wondering what I should add to may init.d script, fast
or immediate. The 8.3 doc says:
'"Fast" mode does not wait for clients to disconnect.
PostgreSQL 8.2.9 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404
(Red Hat 3.4.6-9)
with autovacuum = on
I'm getting these warnings:
2009-08-12 10:36:24 EDT,5509339,VACUUM WARNING: skipping "sql_sizing_profiles"
--- only table or database owner can vacuum it
for various informa
>From interop attending, IT golf guys:
"Yet 55 percent told the network analysis vendor they experience more
problems than benefits with the technology, while the remaining 45 percent
said they had realized the benefits of virtualization. Among the problems
were a lack of visibility and tools to t
On Thu, May 07, 2009 at 09:58:04AM -0700, Joshua D. Drake wrote:
> Because "users" shouldn't compile. The commands aren't relevant. If
> possible you should *always* run from your package manager.
don't you need root to do package management? Maybe that is just
Red Hat like. Hmm, not on OS X.
>
On Thu, May 07, 2009 at 07:49:56AM -0500, Ries van Twisk wrote:
> I hope you don't compile 8.2.11 now from source, right?
I never understood this attitude. Do this commands really
make for a daunting adventure. Why the trepidation?
http://www.postgresql.org/docs/8.2/interactive/install-short.
On Thu, May 07, 2009 at 04:38:59AM -0700, Jan Muhammad wrote:
> Hi,
>
> I have just downloaded, installed/configured postgresql version 8.2.11 on
> Fedora Core 6. While reading through the installation manual have setup most
> of its parts; now while trying to run datebase server with the comman
On Mon, May 04, 2009 at 09:06:48AM -0400, Ray Stell wrote:
>
> So, you are saying just shutdown, but it is my experience that this might not
> work and I need to script this for the operator to do the maintenance.
Could not get the standby to go down without flags, which makes m
On Sat, May 02, 2009 at 12:13:42AM -0400, Robert Treat wrote:
>
> First tip, dont use -i, it isn't needed. I'd try withought any flag and work
> up if needed. Be patient unless you can't afford to be.
thanks, Robert, I assume you mean don't use -m i, I don't see a -i anywhere.
So, you are sa
I need to do OS maintenance on a system running a standby in recovery
using pg_standby. I've gotten mixed results with doing the stop/start
with pg_ctl. Sometimes the standby is not recoverable. What should
the shutdown script look like if the standby is to be usable on the
other side? The log
On Tue, Mar 17, 2009 at 03:27:42PM +0100, Lori, Giancarlo wrote:
> Thanks to all, I have solved, I have been able to restart the Postgres db,
> and then after a pg-dump I have created a new one.
> Thanks again
I'd like to learn from your experience. Perhaps you would be willing to
expand on the
On Tue, Mar 17, 2009 at 12:01:01PM +0100, ad...@informatyka.gdansk.pl wrote:
> On Tue, 17 Mar 2009 09:50:55 +0100, "Lori, Giancarlo"
> wrote:
> > the postmaster process run, but any command pg_dump, etc I try to
> > execute failed. The system respond that there are not database in the
> > system.
On Wed, Mar 04, 2009 at 03:14:51PM -0500, Ray Stell wrote:
> On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote:
> > Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
> > bind. It seems like it may be waiting for some WAL. How can I tell
>
On Thu, Mar 05, 2009 at 10:04:44AM -0500, Yauheni Labko wrote:
> You gave the recovery command, not the archive command.
I'm curious why you are focused on the archive on the primary?
Is there some logic in the archive process that could cause the recovery to
be looking for
/data/pgsql/wals/al
On Wed, Mar 04, 2009 at 05:05:19PM -0500, Yauheni Labko wrote:
> No. %f is the WAL filename which is needed by the server to start recovery.
my recovery command is:
restore_command='/usr/local/pgsql/bin/pg_standby /data/pgsql/wals/alerts_oamp
%f %p %r >> /home/postgresql/log/alerts_oamp/recove
On Wed, Mar 04, 2009 at 03:41:06PM -0500, Yauheni Labko wrote:
> For some reason it is looking for 0002001C.00512178.backup
> file which is not the WAL file.
>
> Are you sure that you made initial recovery properly?
I could have fouled this in any number of ways. Like I said
I'
On Wed, Mar 04, 2009 at 08:31:16PM +, Simon Riggs wrote:
> You've set archive_timeout?
>
no, but new WAL files seem to be getting created and replicated to the standby,
just the pg_standby
command seems snagged on something. I probably have done something dumb,
ready, fire, aim. I'm
mo
On Wed, Mar 04, 2009 at 03:06:12PM -0500, Ray Stell wrote:
> Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
> bind. It seems like it may be waiting for some WAL. How can I tell
> what it is waiting on? I don't really know how this works, so I m
Testing pg_standby in 8.3.6. I've gotten this standby into some sort of
bind. It seems like it may be waiting for some WAL. How can I tell
what it is waiting on? I don't really know how this works, so I may
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes t
btw, no dump is required to flip from 8.3x to 8.3x, but
testing is a good thing.
check the postmaster.pid
[postgre...@swallowtail alerts_oamp]$ cat postmaster.pid
2545
/var/database/pgsql/alerts_oamp
5478001 0
alerts_oamp]$ ps -ef | grep 2545
500 2545 1 0 Jan11 ?00:0
do you have dev installed?
$ rpm -qa | grep readline-dev
readline-devel-5.1-1.1
On Tue, Feb 17, 2009 at 12:06:17PM -0800, Isabella Ghiurea wrote:
> Trying to compile Postgres 8.3.6 and configure fails with readline lib
> missing, I have readline installed , please see all info bellow,
> OS:
I was trying to script a standby role reversal in a 8.3.5 test
environment and something didn't go right. After the reverse of roles the
new standby said:
LOG: invalid resource manager ID in primary checkpoint record
but recovery seemed to pick up. I think the old standby did not go
down cor
On Mon, Feb 02, 2009 at 04:57:21PM -0500, Scott Runnion wrote:
> Surely, given the multi-cultural/multi-national/multi-theological
> users/supporters/advocates of the postgresql and EnterpriseDB developments
> and distributions, the inappropriateness of this declaration by Mr. Momjian
This real
On Fri, Jan 23, 2009 at 02:04:21PM -0500, Carol Walter wrote:
>>>
>>> ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
I don't understand this syntax, is it described somewhere to your
knowledge. The doc say to see the openssl docs, so I went
fishing there. Maybe one of these will work:
> openssl cipher
On Thu, Jan 22, 2009 at 10:35:22AM -0500, Carol Walter wrote:
> I'm still having problems with ssl. My ssl_ciphers line in postgresql.conf
> looks as the following:
>
> ssl_ciphers 'ALL:!ADH:!LOW:@STRENGTH'
this parameter was not available in 8.2.x when I tested so what
I say here has little bas
On Wed, Jan 21, 2009 at 05:01:08PM -0500, Carol Walter wrote:
>
> On Jan 21, 2009, at 4:24 PM, Ray Stell wrote:
>
>> On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
> Also, in the second part of my message there are lines relating to the
> encryption. I'm
On Wed, Jan 21, 2009 at 12:50:23PM -0500, Carol Walter wrote:
> -bash-3.00$ /usr/local/ssl/bin/openssl verify -CAfile ./root.crt
> testcert.pem
> Error loading file ./root.crt
> 24149:error:02001002:system library:fopen:No such file or
> directory:bss_file.c:126:fopen('./root.crt','r')
root.crt
On Fri, Jan 16, 2009 at 01:32:37PM -0500, Carol Walter wrote:
> If I need to rerun configure what else do I have to do.
http://www.postgresql.org/docs/8.3/interactive/install-procedure.html
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
h
On Fri, Jan 09, 2009 at 04:08:00PM -0500, Ray Stell wrote:
> ./configure --prefix=/usr/local/pgsql826
> --with-libraries=/usr/local/openssl/lib
> --with-includes=/usr/local/openssl/include/ --with-openssl
>
>
> On Fri, Jan 09, 2009 at 03:47:54PM -0500, Carol Walter wrote:
&
n? I don't see a parm in postgresql.conf.
>
> Thanks,
> Carol
>
> On Dec 31, 2008, at 4:08 PM, Ray Stell wrote:
>
>> On Wed, Dec 31, 2008 at 11:16:42AM -0500, Carol Walter wrote:
>>>> On the web site you directed me to, the s_server command uses a file
&g
On Wed, Dec 31, 2008 at 11:16:42AM -0500, Carol Walter wrote:
>> On the web site you directed me to, the s_server command uses a file
>> called 'mycert.pem'. Do you know what the system expecting for this file?
It's just a file and you tell openssl where it is, where you put it
once it is creat
On Wed, Dec 31, 2008 at 09:19:12AM -0500, Carol Walter wrote:
> Here's the output from s_client & s_server commands...
>
> # openssl s_client
> connect: Connection refused
> connect:errno=146
oh, I think you need to use some more flags. Take a look at
this howto: http://www.madboa.com/geek/opens
On Tue, Dec 30, 2008 at 03:53:37PM -0500, Carol Walter wrote:
>
> OpenSSL is telling me that ssl is
> not properly configured.
how so?
>> openssl verify -CAfile ./root.crt testcert.pem
can you verify the server crt against the CA?
That is the starting place.
--
Sent via pgsql-admin mailing
On Mon, Dec 29, 2008 at 04:23:30PM -0500, Carol Walter wrote:
> "with openssl" when I initially configured the server. Are there other
> things that need to be done to get openssl started on the database server?
> How can I diagnose this problem?
>
The files server.key, server.crt, root.crt, a
On Sat, Apr 26, 2008 at 11:00:35AM +0530, Kranti K K Parisa? wrote:
> Can anyone suggest a way to retrieve/update the postgres root password ?
edit pg_hba.conf so that localhost connections from localhost are trusted maybe
like
this:
hostall all 127.0.0.1/32 trust
On Tue, Apr 22, 2008 at 09:13:09AM -0600, Scott Marlowe wrote:
> On Tue, Apr 22, 2008 at 8:14 AM, Hajek, Nick <[EMAIL PROTECTED]> wrote:
> It's quite possible you're running your machine out of memory / swap
> somehow and linux is killing the biggest, fattest process it can find,
> which is pgsql.
On Sun, Apr 13, 2008 at 01:50:51AM +0530, Kranti K K Parisa? wrote:
> That means, we have to get the values into specific data types than the
> general string variables?
no, no. Apps can't assume a automatic cast to text. Read the release notes:
http://www.postgresql.org/docs/8.3/static/releas
On Sun, Apr 13, 2008 at 01:17:45AM +0530, Kranti K K Parisa? wrote:
> Will look into that.
There were some list rumblings when 8.3 was released about this
feature:
Non-character data types are no longer automatically cast to TEXT (Peter, Tom)
so, apps will need to be checked for this use.
Upgra
On Sun, Apr 13, 2008 at 12:38:01AM +0530, Kranti K K Parisa? wrote:
> Hi,
>
> We are using PostgreSQL 8.1 version.
> What are the advantages and performance improvement we would get if we move
> to 8.3.
http://www.postgresql.org/docs/8.3/static/release.html
--
Sent via pgsql-admin mailing list
On Thu, Mar 20, 2008 at 10:42:29AM -0400, Tom Lane wrote:
> Ray Stell <[EMAIL PROTECTED]> writes:
> Define "wedged" --- what's the actual problem?
client queries not returning.
> If it is a locking issue then the pg_locks view might be useful.
duh, I meant to c
I have a db wedged and need help dealing with it. How can I
find out more about this, who, what, where, etc, and how
to free this up:
ghiza=# select * from pg_user;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil
| useconfig
-+--+-+---
I have two versions of a db that I'd like to sync from a point-in-time
backup. One set of data is perfered over the other so the db on the
target system will need to be tossed.
Will pg_dump --clean fix up the target or do I need to dropdb instead?
The favored data is in under 8.2.1 and the target
On Wed, Jul 11, 2007 at 06:13:58AM -0700, Mohd Ghalib Akhtar wrote:
> how to download linux 7.3 image file(means os)
google.com
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.
On Tue, Jul 10, 2007 at 07:39:47PM -0400, Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Ray Stell wrote:
> >> Are there critical security or performance patches that should be
> >> applied to 824 and how could I have determined this without
Are there critical security or performance patches that should be
applied to 824 and how could I have determined this without this post?
Thanks.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
ch
1 - 100 of 144 matches
Mail list logo
