you can modify the init.d (or service) file and
add a line to delete the file.
To remove on crash is likely to require some sort of ongoing monitoring
service to see that the process is no longer running.
If you’re already using a service (such as monit) which brings an
application back up after
On 6/22/17 4:36 PM, Adrian Klaver wrote:
On 06/22/2017 01:16 PM, Ray Stell wrote:
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Can you show your complete initdb command
On 6/22/17 4:34 PM, Adrian Klaver wrote:
On 06/22/2017 01:29 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 1:22 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 12:06 PM, Ray Stell mailto:ste...@
On 6/22/17 4:10 PM, Melvin Davidson wrote:
On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver
mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On
startup it
C
On 6/22/17 4:07 PM, Adrian Klaver wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superuser. On startup it
Can you show your complete initdb command?
throws these msgs:
2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgr
thoughts.
—Ray
I used "initdb -U" to specify an alternate superuser. On startup it
throws these msgs:
2017-06-22 14:36:34 EDT,0,startup FATAL: 28000: role "postgresql" does
not exist
2017-06-22 14:36:34 EDT,0,startup LOCATION: InitializeSessionUserId,
miscinit.c:503
--
Sent via pgsql-general mailing
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
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
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/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/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/
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
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 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:
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
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
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
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 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
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
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
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 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 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&
sql.org/docs/9.3/interactive/tutorial-accessdb.html
Regards,
Ray
signature.asc
Description: Message signed with OpenPGP using GPGMail
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.
On Apr 4, 2014, at 12:03 AM, François Beausoleil wrote:
> I have some performance issues on a Ubuntu 12.04 which I'd like to resolve.
> iowait varies a lot, between 5 and 50%.
Is the SAN dedicated to this app? I wonder if the i/o, if not related to your
app, is being pressed by some other s
On Mar 23, 2014, at 7:58 PM, Álvaro Nunes Lemos Melo wrote:
...
> the whole system is slower.
>
> Below is my data, and I really hope we can find what is happening, or I'll
> have to downgrade to 9.2 and wait for 9.4 release.
I think this is a good starting place:
http://wiki.postgresql.org/w
On Jan 17, 2014, at 5:07 AM, Granthana Biswas wrote:
> Yes it's purely for monitoring purpose.
>
I use the pg_controldata cmd locally and via bash/ssh shared keys and compare
various values that seem interesting such as "Time of latest checkpoint, Latest
checkpoint location." My interest i
On Sep 23, 2013, at 4:47 PM, John DeSoi wrote:
>
> You mean on the primary, right?
right
> Yes, I have one there. But even if I did not, I would expect to see a
> connection error in the log on the standby. No error or any indication the
> streaming replication process is running on the stan
On Sep 23, 2013, at 11:20 AM, John DeSoi wrote:
>
> Am I missing something obvious? Do I have to back up the primary again to
> make this change?
you didn't mention a pg_hba.conf rule. did you add one for the replication
user?
--
Sent via pgsql-general mailing list (pgsql-general@postgres
On Sep 17, 2013, at 7:22 AM, "Echlin, Jamie (KFIA 611)"
wrote:
> Unfortunately though if there is heavy load, the wal files will be generated
> more regularly than the 5 minute max.
If you wrote the WAL to an external, mounted disk, wouldn't that solve the
issue?
On Sep 13, 2013, at 3:51 PM, Raymond O'Donnell wrote:
> [1] and one of the wiki
> articles [2] seem to indicate that you need to set up log-shipping as
> well as SR, whereas one of the wiki articles [2] indicates that
> log-shipping isn't required. I've followed [3] and it seems to work fine
> in
On Jul 26, 2013, at 1:42 PM, Tim Spencer wrote:
> On Jul 25, 2013, at 11:45 PM, Joe Van Dyk wrote:
>> Have chef supply the password in encrypted format.
>>
> I was hoping that somebody would be able to solve my logging issue instead
> of me having to rejigger my nice centralized password syst
- 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
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
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
- 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
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
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
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
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
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
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
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 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 Nov 29, 2012, at 9:27 AM, Kevin Grittner wrote:
> is everything shown there really
> the behavior of the MySQL database itself?
Good question. I intend to install mysql one day to explore, but just can't
find the time. The particular engine is not disclosed and I've read some are
better th
turn the vol down a bit:
http://www.youtube.com/watch?v=1PoFIohBSM4
the answer is d)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Sat, Apr 14, 2012 at 09:01:10AM +, Albretch Mueller wrote:
>
> I wonder if anyone has ever gotten PostgreSQL Certified
https://www.google.com/search?q=postgresql+certification&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
--
Sent via pgsql-general mailing list (
I've been using a network management tool for a number of years from
cisco to manage storage networking (fibre channel). The thing is
called Fabric Manager and I was thrilled that they supported pg for the
backend when I first installed. However, their latest and greatest is
frozen to pg 8.2. Si
On Mon, Dec 05, 2011 at 12:16:29PM +0100, Frank Lanitz wrote:
> Hi list,
>
> We had in past from time to time the issue, that the standby server is
> stopping recovering, creating a new timeline and become up and running.
> In parallel to check for the reasons of this behavior we are looking for
>
On Tue, Aug 23, 2011 at 08:30:55PM +0530, Raghavendra wrote:
>
> Is it a best practice to keep cluster in Archive_mode = on and setup
> streaming replication or just leave archive_mode=off?
Depends. The reason for creating WAL is in case they are needed for recovery.
In the event that the stby h
On Tue, Aug 23, 2011 at 06:23:58AM -0700, Adrian Klaver wrote:
> On Tuesday, August 23, 2011 4:14:15 am Ray Stell wrote:
> > On Tue, Aug 23, 2011 at 02:01:10AM -0700, alexondi wrote:
> > > Hi!
> > > Do I need setup wal archiving (archiving_mode = on) setup when I use
On Tue, Aug 23, 2011 at 02:01:10AM -0700, alexondi wrote:
> Hi!
> Do I need setup wal archiving (archiving_mode = on) setup when I use
> streaming replication?
yes
http://www.postgresql.org/docs/current/interactive/high-availability.html
--
Sent via pgsql-general mailing list (pgsql-general@pos
On Wed, Aug 10, 2011 at 02:47:25PM -0400, Geoffrey Myers wrote:
> Is max connections in any table in the database I can access?
edbstore=> \d pg_catalog.pg_settings;
View "pg_catalog.pg_settings"
Column | Type | Modifiers
+-+---
name | text|
sett
On Sun, Jun 12, 2011 at 01:41:14PM +0300, abiy hailu wrote:
> Considering the fact that it is a critical service, what can be implemented
> to improve the postgreSQL service.
take a look at these books and see which one fits your needs:
http://www.postgresql.org/docs/books/
--
Sent via pgsql-gen
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 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
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
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
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
> 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
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
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
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
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 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
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
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
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
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
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, 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
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
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
> 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.
> >
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
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 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, 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 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 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
> -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 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
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
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
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
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
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
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 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
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
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
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
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 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 Tue, Aug 17, 2010 at 11:02:20AM +0700, tuanhoanganh wrote:
> On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh wrote:
> > The process cannot access the file because it is being used by another
> > process.
> > C:\...\8.3\pg_xlog\00010007001B
Exclude pg_log from the backup or rm that f
On Tue, May 04, 2010 at 05:12:16PM +0600, AI Rumman wrote:
> I change the pg_hba.conf as below:
and you restart or do a pg_ctl reload?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Apr 13, 2010 at 06:28:18PM +0530, Satish Burnwal (sburnwal) wrote:
>
> In such a case what can I do ?
don't crosspost?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
1 - 100 of 206 matches
Mail list logo
