nd closed the
console.
I would like to export an Excel file as CVS and ;'copy' into pg. So I
would like to learn how to create a new database and what ever goes
along with that to acheive this goal.
I would appreciate all help.
Thanks,
ray
--
Sent via pgsql-general mailing list (pg
pen in the shell.I have
tried creating a database in the shell but failed. I was able to
create one in pgAdmin III. I have read a copy tutorials but have not
been able to find one that is a simple step by step.
I would appreciate any help in learning how to learn.
ray
--
Sent via pgsql-general ma
laptop but got the same error:
Could not open the specified URL.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Nov 12, 10:03 am, sachin.srivast...@enterprisedb.com (Sachin
Srivastava) wrote:
> Can you open the specified URL in the browser?
>
> On Nov 12, 2010, at 4:24 PM, ray wrote:
>
> > I just downloaded 9.0 onto my laptop and desktop Windows XP
> > machines. .Nether one cou
On Nov 10, 11:07 pm, robjsarg...@gmail.com (Rob Sargent) wrote:
> ray wrote:
> > I just downloaded 9.0 onto my laptop and desktop Windows XP machines.
> > Nether one could run the stack builder. Windows would fault any time
> > I tried to run it. I tried inputing the prox
On Nov 17, 8:42 pm, Ray wrote:
> Hi,
>
> I have a table column name is called begin, tried to move it to
> postgresql9 from postgresql8.4. the function failed to call
> New.begin.
>
> here is a quick test.
>
> CREATE TABLE test(id serial primary key not null, begin ti
Hi,
I have a table column name is called begin, tried to move it to
postgresql9 from postgresql8.4. the function failed to call
New.begin.
here is a quick test.
CREATE TABLE test(id serial primary key not null, begin timestamp
without time zone not null);
CREATE TABLE test2(id bigint not null, b
nt'. I was then
able to start the server from both the Serves app and from AdminIII.
I am listed as a user in the domain. The postgres user is listed for
the machine.
I hope this helps others. I hope I can find this the next time I get
stuck.
ray
keywords: postgresql, server, services, start, fa
Manager]
Data source name not found and no default driver specified”.
The driver is supposed to be inside of a pgsql DLL but I don’t know
how Windows is supposed to find it. How should I set up the
connection string?
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Dec 13, 1:15 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 13/12/2010 18:46, ray wrote:
>
> > I do not know if I should leave the {PostgreSQL} as is or should it be
> > replaced with something.
> > For Server, the connection is on the same machine s
simple method to implement the design.
I would like to find a simple guide, tutorial or example and will
appreciate any help.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
This has been a great thread! I am missing something because I do not
know what CTAS is. WOuld someone please help me understand.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
csv' WITH DELIMITER ',' NULL '' CSV HEADER;
ERROR: relation "equpment_list_sheet2" does not exist
** Error **
ERROR: relation "equpment_list_sheet2" does not exist
SQL state: 42P01
___
Thanks for any help,
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ailing list (pgsql-gene...@postgresql.org)
> To make changes to your
> subscription:http://www.postgresql.org/mailpref/pgsql-general
I am interested in reporting also.
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mar 10, 4:59 am, s...@compulab.co.il (Sim Zacks) wrote:
> On 03/10/2011 12:36 PM, ray wrote:
>
>
>
> > On Jan 17, 3:39 pm, byrn...@harte-lyne.ca ("James B. Byrne") wrote:
> >> I have occasion to produce reports from our PostgreSQL database
> >> whic
multiple spreadsheets (tabs) for each of the
tables in the third dimension. Then save the needed interconnection
info as a CSV file for import into other applications.
I will appreciate any suggestions, insights, questions and comments.
Thanks,
ray
--
Sent via pgsql-general mailing list (pgsql
ct or indirect."
I looks like a tagged PDF will reflow on supporting devices such as
kindle. EPUB seems to be an alternative.
http://www.google.com/search?q=pdf+reflow&hl=en&num=10&lr=&ft=i&cr=&safe=images&tbs=
ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have just installed 8.4 on an XP. My intent is to use it with Trac
and Apache.
I would like to validate the installation of pgsql. What would be a
good method to make sure that pgsql is in there right?
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
erver pane showed "Servers(0)". I
tried to add server where Host = localhost, but I get "Server Doesn't
Listen".
I would appreciate any suggests on how to better prepare and execute
an installation.
Thaks,
ray
-
Sent via pgsql-general mailing list (pgsql-general@post
On Mar 18, 5:07 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 18/03/2009 21:10, ray wrote:
>
> > I downloaded the 8.3 exe for Windows (XP) and started the
> > installation. When it got near the end, a warning window opened
> > stating "Problem runn
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 18/03/2009 22:22, ray wrote:
>
> > I do not see an opportunity to request a log to be written. From the
> > Psotgre site, I downloaded:
> > postgresql-8.3.7-1-windows.exe
>
> Ah, I s
On Mar 19, 2:04 pm, r...@iol.ie ("Raymond O'Donnell") wrote:
> On 18/03/2009 22:22, ray wrote:
>
> > I do not see an opportunity to request a log to be written. From the
> > Psotgre site, I downloaded:
> > postgresql-8.3.7-1-windows.exe
>
> Ah, I s
user. The installer liked that.
But when the installation progressed to choosing languages, Python was
no longer shown as available. I accepted the only one available and
proceded. . . Not it works.
The problem is I need Python functionality for Trac. Can I add it?
How do I get where I need
don't know if this has any relationship, but when I installed 8.3, I
tried to use myadminaccnt as the user name but it said that was
missing a right so I elected to let 8.3 build a user "postgreadmin"
with the same password.
How can I go forward? When I build this again on
On Mar 28, 12:57 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Sat, Mar 28, 2009 at 4:21 PM, Scott Mead
>
>
>
>
>
> wrote:
>
> > On Sat, Mar 28, 2009 at 3:51 AM, ray wrote:
>
> >> I have installed 8.2 on a Windows 2000 laptop.
>
> >> I think
e should it be placed?
When I rename the dll to python26, the PL installed without error.
But I am concerned that something else is wrong. I would really like
to find out how to get this to install correctly on production
machines.
Ray
--
Sent via pgsql-general mailing list (pgsql-general@post
ation directory"? So I may better
identify the correct folder, what subfolders might the correct JDBC
folder have?
TIA,
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Mar 30, 2:55 am, dp...@pgadmin.org (Dave Page) wrote:
> On Mon, Mar 30, 2009 at 1:51 AM, ray wrote:
> > I am trying to get Python 2.6 and PostgreSQL 8.3 to work together
> > under Windows 2000.
>
> > When I try to add Python to PostgreSQL via:
> > createlang p
On Apr 15, 3:15 pm, ray wrote:
> I have just installed pgsql on a Windows XP from my administrator
> 1) The encoding is win1252, I wanted to make it unicode but I missed
> where to make that happen. Can I change it for those things already
> built and for things in the future?
mmands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
Warning: Console code page (437) differs from Windows code page (1252)
8-bit characters might not work correctly. See psql reference
page "Notes for Windows users" for details.
End of post.
Thanks,
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Apr 15, 4:17 pm, ray wrote:
> On Apr 15, 3:15 pm, ray wrote:
>
> > I have just installed pgsql on a Windows XP from my administrator
>
I closed down everything and tried to start back up and failed. From
pgAdmin, there is a red 'x' in the icon for my new server.
On Apr 15, 5:50 pm, ray wrote:
> On Apr 15, 4:17 pm, ray wrote:
>
I am trying to re-installed PostgreSQL. I have chosen a different
process. I am installing it as a service. After much time at the
'Starting Services' window, it says that I have insufficient
previleges to start
ssing that is due to the no ‘data’ folder.
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Apr 21, 9:55 am, plk.zu...@gmail.com (Filip Rembiałkowski) wrote:
> 2009/4/20 ray
>
>
>
>
>
> > I have been having troubles getting 8.3 running on Windows XP. My
> > last couple of attempts have been to install 8.3 in a folder off the
> > root rather t
On Apr 16, 1:35 pm, ray wrote:
> On Apr 15, 5:50 pm, ray wrote:> On Apr 15, 4:17 pm,
> ray wrote:
>
> I am trying to re-installed PostgreSQL. I have chosen a different
> process. I am installing it as a service. After much time at the
> 'Starting Services&#x
On Apr 20, 1:29 pm, ray wrote:
> I have been having troubles getting 8.3 running on Windows XP. My
> last couple of attempts have been to install 8.3 in a folder off the
> root rather than off of 'Program Files'. Since I ‘uninstalled’ it, I
> have not been able to get a
number for each change during that day.
I would like to know what triggers the name change and how can I force
a change.
Thanks,
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I have been using postgresql in java off and on for many years. I now
have an assignemtn where I have to build a very straight forward networked
application that needs to be able to insert Array data types from a windows
environment to a remote Linux Postgresql database.
My first attempt was to
ldn't include your email in my response tell me, I am not sure
what the conventions are.
On Sun, Apr 5, 2015 at 1:35 PM, Adrian Klaver
wrote:
> On 04/05/2015 01:21 PM, Ray Madigan wrote:
>
>> I have been using postgresql in java off and on for many years. I now
>> have a
On Sun, Apr 5, 2015 at 6:46 PM, Steve Atkins wrote:
>
> On Apr 5, 2015, at 1:21 PM, Ray Madigan wrote:
>
> > I have been using postgresql in java off and on for many years. I now
> have an assignemtn where I have to build a very straight forward networked
> application
ary key.
Alternatively, if the numbers are very large or very small, you may want to
try converting the binary data into a BINHEX value and use that textual
representation as the primary key.
Either way, I think you'd be saving yourself a lot of headaches using a
representation that is not 'inexact.'
--Ray
--
Raymond Cote, President
voice: +1.603.924.6079 email: rgac...@appropriatesolutions.com skype:
ray.cote
On Sat, Aug 22, 2015 at 11:46 AM, Karsten Hilbert
wrote:
> > 1. Prefix ALL literals with an Escape
> >EG: SELECT E'This is a \'quoted literal \'';
> > SELECT E'This is an unquoted literal';
> >
> >Doing so will prevent the annoying "WARNING: nonstandard use of
> escape in a stri
Is there an preferred BDR? Should there be a mailing-list?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ant.com/en/resources/bdr/
Might want to edit here:
http://bdr-project.org/docs/stable/appendix-signatures.html
" The BDR / 9.4 RPM releases key key is in turn signed..."
Thanks,
Ray
This doc specifies to initdb with the admin user "postgres,"
http://bdr-project.org/docs/stable/quickstart-instances.html
but if I do that the supervisor falls over with:
$ cat bdr5598.log
LOG: registering background worker "bdr supervisor"
LOG: database system was shut down at 2015-09-02 16:04:
I have lost/forgotten the postgres password for my installation so I did the following.I edited pg_hba.conf and added an entry: local all all trustrestarted postgresql. loged in as postgres (psql template1 -U postgres) change the postgres password withALTER ROLE postgres PASSWORD fooI edited pg_h
This doc: http://bdr-project.org/docs/stable/installation-source.html
at section: 3.3.3. Installation of BDR from source
needs to have a "make install" added here:
cd /path/to/bdr-plugin-source/
PATH=/path/to/install:"$PATH" ./configure
make -j4 -s all
--
Sent via pgsql-general m
On 9/3/15 11:36 PM, Craig Ringer wrote:
Please show your connection strings, and the contents of bdr.bdr_nodes
and bdr.bdr_connections.
On 3 September 2015 at 05:00, Ray Stell wrote:
This doc specifies to initdb with the admin user "postgres,"
http://bdr-project.org/docs/stable/
On 9/6/15 10:55 PM, Craig Ringer wrote:
On 4 September 2015 at 21:46, Ray Stell wrote:
FATAL: role "postgresql" does not exist
It works if I init with "-U postgresql"
The demo works fine if
I use the string "postgresql" as the admin role. It looks like you
On 9/8/15 2:33 AM, Craig Ringer wrote:
On 7 September 2015 at 20:34, Ray Stell wrote:
On 9/6/15 10:55 PM, Craig Ringer wrote:
On 4 September 2015 at 21:46, Ray Stell wrote:
I don't see this in my tests. Can you confirm the exact BDR version
you're testing/using? "git re
On 9/9/15 1:43 AM, Craig Ringer wrote:
$ git rev-parse --short HEAD
6a60690
$ git branch
* bdr-pg/REL9_4_STABLE
OK, that's PostgreSQL. What about the BDR extension its self?
SELECT bdr.bdr_version() will show you if you're starting up OK,
otherwise again the git rev please.
bdrdemo=# SELECT
I am attempting to setup a small postgresql database on a beaglebone black. The application is slow so I am storing the database on a 64GB microsd card. I formatted the drive, mounted it all correctly.I logged in as postgressudo su postgres# create the database cluster./initdb /data # the mou
What is listen_addresses set to in postgresql.conf?
'*' corresponds to all available IP interfaces. Maybe
you are not listening on localhost.
On Thu, May 31, 2007 at 08:57:41AM -0400, Bhavana.Rakesh wrote:
> Ok,
> I confirmed that I'm editing the right pg_hba.conf file. I made sure
> that th
What does netstat -l tell us about that?
On Thu, May 31, 2007 at 02:50:50PM +0100, Oliver Elphick wrote:
> On Thu, 2007-05-31 at 09:38 -0400, Bhavana.Rakesh wrote:
> > Hi,
> > Here's what happens when I specify the port number
> >
> > [EMAIL PROTECTED] ~]$ psql -U brakesh -p 5000 -h 127.0.0.1 -
On Thu, May 31, 2007 at 04:07:25PM -0400, Tom Lane wrote:
> the kernel rejected the connection before looking for a listening process.
or a host-based firewall might produce the same result.
---(end of broadcast)---
TIP 3: Have you checked our exten
On Mon, Jun 04, 2007 at 09:49:03AM +0100, John Gardner wrote:
> /var/lib/pgsql/data/. Shall I just create a directory under here and
> point the tablespace to there? Any advice would be appreciated.
One of the points of ts is to balance io over different controllers/disks.
Someone should evalula
take a look inside the rpm and see what it installed:
rpm -ql
On Thu, Jun 07, 2007 at 10:51:59AM +0200, phillip wrote:
> hie i am a newbie to Postgresql. I installed Postgresql using an rpm. my
> problem is that when i issue the service postgresql start command the
> database is failing to
On Mon, Jun 11, 2007 at 12:55:08PM +0200, hubert depesz lubaczewski wrote:
> you can modify log_line_prefix to contain database name.
%d = database name
restart required
a trigger might be cleaner.
> depesz
>
> On 6/11/07, Rikard Pavelic <[EMAIL PROTECTED]> wrote:
> >
> >Hi!
> >
> >I'm looki
where does a 500 lb gorilla sit?
http://www.networkworld.com/news/2007/102307-mysql-to-get-injection-of.html?netht=102407dailynews1&&nladname=102407dailynews
The companies are in close contact, Axmark said. The Google engineer in
charge of its MySQL deployments spent several days at MySQL's inte
I was pleased to read that cisco's MDS management software supports
having pg in the backend:
http://www.cisco.com/univercd/cc/td/doc/product/sn5000/mds9000/3_0/fmcfg/part01/gs.htm#wp521101
Supported Software
Databases
Oracle Database 10g Express
PostgreSQL 8.2 (Windows)
PostgreSQL 8.1 (Solari
On Wed, Oct 13, 2010 at 09:44:44AM +0200, Derk Jan Horstman wrote:
> > I downloaded rpms from below site.
> > http://www.postgresql.org/ftp/binary/v9.0.1/linux/rpms/redhat/rhel-5-x86_64/
> >
> >
> > 1. enable thread safety?
> > "--disable-thread-safety" is given.
Where is the flag "given?"
On Mon, Nov 01, 2010 at 11:54:25AM -0400, zhong ming wu wrote:
> I don't recall this being an issue with 8.4 I am also using
>
> Say your 8.1 server has SSL on. Even though pg_hba.conf have
>
> host or hostnossl md5
>
> either server or 8.1 psql insists that you have .postgresql/postgresq
On Tue, Dec 07, 2010 at 05:15:45PM -0500, James B. Byrne wrote:
>
> On Tue, December 7, 2010 16:56, Joshua D. Drake wrote:
>
> >
> > No those lib differences are both still 32bit. You would have a
> > problem if one was 64bit. So you should be fine there.
> >
> > Joshua D. Drake
> >
>
> Ok. How
> -Original Message-
> From: Susan Cassidy [mailto:scass...@stbernard.com]
> Sent: Monday, December 13, 2010 2:06 PM
> To: ray; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Defining a Connection String in Windows XP
>
> >Ray,
> >
> >Thank
On Thu, Dec 16, 2010 at 06:33:25PM -0600, Edmundo Robles L. wrote:
> hi! i have postgresql 8.3.12 and i got the eror:
> PANIC: ERRORDATA_STACK_SIZE exceeded
>
if (++errordata_stack_depth >= ERRORDATA_STACK_SIZE)
{
/*
* Wups, stack not big enou
On Wed, Jan 26, 2011 at 02:22:41PM -0800, Dan Birken wrote:
> > Can you give some concrete suggestions on what needs to be added? The
> > current documentation is here:
> >
> >http://developer.postgresql.org/pgdocs/postgres/index.html
I had some difficulty getting the keepalives syntax i
On Wed, Jan 26, 2011 at 09:18:01PM -0500, Bruce Momjian wrote:
>
> Uh, the sentence is:
>
> On systems that support the keepalive socket option, setting
> tcp_keepalives_idle, tcp_keepalives_interval and tcp_keepalives_count
> helps the primary promptly notice a broken connectio
On Wed, Jan 26, 2011 at 09:02:24PM -0500, Ray Stell wrote:
> On Wed, Jan 26, 2011 at 02:22:41PM -0800, Dan Birken wrote:
> > > Can you give some concrete suggestions on what needs to be added? The
> > > current documentation is here:
It seems like there is a departure in p
On Wed, Feb 02, 2011 at 08:52:02AM -0700, Gauthier, Dave wrote:
> I'm going to be experimenting with streaming replication using v9.0.1. Here
> are a few questions I have at the onset...
why not 9.0.2?
> 5) Is there a step-by-step "how to" document for this?
http://wiki.postgresql.org/wiki/Bi
> On Saturday, February 05, 2011 9:30:13 am ray wrote:
> > I have built a few databases with MS Access and I would like to learn
> > how to use pgsql. I have found some examples but they have been too
> > complex to follow or to abstract with no specific details.
> >
Notepad++, how do you launch the code?
I really appreciate your efforts.
ray
_
From: urlu...@gmail.com [mailto:urlu...@gmail.com] On Behalf Of Matt
Sent: Saturday, February 05, 2011 10:19 PM
To: ray joseph
Subject: Re: [GENERAL] Looking for Suggestion on Learning
I too
pg_controldata command is helpful.
Archiving wal not required, but you can roll it either way.
On Tue, Feb 08, 2011 at 04:46:51PM -0600, Ogden wrote:
> Hello all,
>
> I have set up PostgreSQL Streaming Replication and all seems to work fine
> when updating records as the records are inst
On Tue, Feb 08, 2011 at 08:51:42PM -0600, Ogden wrote:
>
> On Feb 8, 2011, at 8:47 PM, Ray Stell wrote:
>
> >
> > pg_controldata command is helpful.
> >
> > Archiving wal not required, but you can roll it either way.
> >
> >
>
> That is my
p without
wal archiving in place seems to be corrupted. I think you will be
interested in it. I could have tacked it on here, but I thought it
needed to stand out.
Regards,
Ray
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
On Tue, Mar 01, 2011 at 06:37:35PM +0530, Adarsh Sharma wrote:
>
> But I want to start it after booting automatically.
>
http://embraceubuntu.com/2005/09/07/adding-a-startup-script-to-be-run-at-bootup/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your
I appreciate all the information
Thank you,
ray
-Original Message-
From: Dimitri Fontaine [mailto:dimi...@2ndquadrant.fr]
Sent: Sunday, March 06, 2011 3:19 PM
To: ray
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How to Create Table from CSV
ray writes:
> I would like
On Mon, Mar 07, 2011 at 12:34:19PM -0500, runner wrote:
>
> I'd like to know if any of you have ever installed a PostgreSQL database for
> production use and then found something you wish you had done differently
> after the fact.
Test and document your disaster recovery plan. You don't wa
nt on designing for efficient representation rather
than use cases. I am guessing that means normalization?
ray
-Original Message-
From: David Johnston [mailto:pol...@yahoo.com]
Sent: Sunday, March 20, 2011 9:05 AM
To: 'ray'; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Data
> From: Andy Colson [mailto:a...@squeakycode.net]
> Sent: Sunday, March 20, 2011 9:01 AM
>
> On 03/19/2011 11:40 PM, ray wrote:
> > I am looking for some help in database design. I would like to design
> > a database to help design alternative designs of a basic elect
ify it, it'll be
> generated for you.
>
>
> >
> > I have a general question. I see that you consistently use very short
> > abbreviations such as did and cid. I have used short, medium and long.
> > Short are great for inputting but I am always looking up what
What does the results in col 'List of schemas Access privileges'
indicate? Are those three results split by the '/' char? What
are the three sections? What is 'postgres+'
Can't find this explained in the docs.
template1-# \dn+ pg_catalog
List of schemas
Name
On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
>
> Following are details:
> postgres=UC/postgres+
> [user] [privs] /[ ROLE who granted privs.
What's the logic for reporting the U priv twice?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make chang
On Tue, Apr 05, 2011 at 06:33:46PM +0530, Vibhor Kumar wrote:
>
> On Apr 5, 2011, at 6:07 PM, Ray Stell wrote:
>
> > On Tue, Apr 05, 2011 at 03:58:46PM +0530, Vibhor Kumar wrote:
> >>
> >> Following are details:
> >> postgres=UC/postgres+
>
On May 30, 2014, at 6:19 PM, Kapil Agarwal wrote:
> Slave server:
>
> select pg_last_xlog_receive_location();
>
not possible back in 8.4. you could just compare the output of the
pg_controldata command on both hosts.
sql.org/docs/9.3/interactive/tutorial-accessdb.html
Regards,
Ray
signature.asc
Description: Message signed with OpenPGP using GPGMail
On Aug 6, 2014, at 12:28 PM, Bill Epstein wrote:
> I'm very new to Postgres, but have plenty of experience developing stored
> procs in Oracle.
>
I found this helpful:
http://www.amazon.com/PostgreSQL-Server-Programming-Hannu-Krosing-ebook/dp/B00DMYO2D2/ref=tmm_kin_swatch_0?_encoding=UTF8&
On Aug 6, 2014, at 6:56 PM, Frank Pinto wrote:
>
> and make sure you restarted the server so your changes take effect.
>
reload will get it, also, and is sometimes easier to come by.
The pg_hba.conf file is read on start-up and when the main server process
receives a SIGHUP signal. If you e
On Oct 9, 2014, at 4:30 PM, Rob Flemming wrote:
> 2014-10-09 12:59:40 PDT CONTEXT: line 1 of configuration file
> "C:/postgres/pg_hba.conf"
> 2014-10-09 12:59:40 PDT FATAL: could not load pg_hba.conf
what’s on line 1 of pg_hba.conf?
signature.asc
Description: Message signed with Op
On Feb 23, 2013, at 11:05 PM, Maz Mohammadi wrote:
>
> FATAL: connection requires a valid client certificate.
I use openssl to verify the chain, I think that would help you know what's
going on:
openssl verify -CAfile rootca.crt user.crt
On Mar 7, 2013, at 9:37 AM, Ian Pilcher wrote:
> On 03/07/2013 08:28 AM, Tom Lane wrote:
>> Maybe I'm missing something, but I don't see why you'd expect a
>> different result. That leaves you with no way to validate the server's
>> own certificate.
>
> I don't follow. Why would the server nee
On Mar 18, 2013, at 7:36 PM, Christophe Pettus wrote:
> Are is the contents of the .backup file (generated by pg_stop_backup())
> documented anywhere? (Some of it is self-explanatory, of course). If not,
> is there a quick summary of what START WAL LOCATION, STOP WAL LOCATION, and
> CHECKPOI
Forwarding a post seen on an oracle list this morning as Stephane has been quite
an inspiration over the years and he is covering postgresql in this text:
Some list members may be adjunct or full-time faculty members and
interested by the fact that I'm currently working on a 450-page textbo
A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for
superuser, -u, does not get carried to a -U flag on the vacuumdb commands
written to analyze_new_cluster.sh.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www
On May 13, 2013, at 12:20 AM, Tsunakawa, Takayuki wrote:
> I'm not sure whether there are any situations where the DBAs need to use
> different username/password pairs for the OS user who starts/stops the
> database server, and the database superuser.
I was thinking obscurity might be a good f
On May 21, 2013, at 2:41 PM, Bruce Momjian wrote:
> On Wed, May 8, 2013 at 08:52:40PM -0400, Bruce Momjian wrote:
>> On Wed, May 8, 2013 at 05:05:05PM -0400, Ray Stell wrote:
>>> A minor detail in 9.2.4, but I noticed that the pg_upgrade flag for
>>> superuser, -u, d
pointers as to how I go about identifying the root cause of this
problem.
Thanks.
--Ray
------
Ray Cote, President Appropriate Solutions, Inc.
We Build Software
www.AppropriateSolutions.com 603.924.6079
--
Sent via pgsql-general mailing list (pgsql-g
- Original Message -
> From: "bricklen"
> To: "Ray Cote"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 3:44:04 PM
> Subject: Re: [GENERAL] Database performs massive reads when I'm doing
> writes.
> On
of read activity.
The load_rets.py task is the Python script loading the database.
--Ray
- Original Message -
> From: "Jeff Janes"
> To: "Ray Cote"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 4:05:28 PM
> Subject: Re: [GENER
leads everyone sent me.
Learned a lot about Postgresql today.
--Ray
- Original Message -
> From: "Ray Cote"
> To: "Jeff Janes"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 5:12:51 PM
> Subject: Re: [GENERAL] Database performs massive
- Original Message -
> From: "Jeff Janes"
> To: "Ray Cote"
> Cc: pgsql-general@postgresql.org
> Sent: Thursday, June 6, 2013 5:41:00 PM
> Subject: Re: [GENERAL] Database performs massive reads when I'm doing
> writes.
> On
1 - 100 of 206 matches
Mail list logo
