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
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 01:13 PM, Jeff Janes wrote:
On Thu, Jun 22, 2017 at 1
On 6/22/17 4:10 PM, Melvin Davidson wrote:
On Thu, Jun 22, 2017 at 4:07 PM, Adrian Klaver
<adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com>> wrote:
On 06/22/2017 12:06 PM, Ray Stell wrote:
I used "initdb -U" to specify an alternate superus
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 "po
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
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 <ste...@vt.edu> wrote:
On 9/6/15 10:55 PM, Craig Ringer wrote:
On 4 September 2015 at 21:46, Ray Stell <ste...@vt.edu> wrote:
I don't see this in my tests. Can you confirm the exact BDR version
yo
On 9/6/15 10:55 PM, Craig Ringer wrote:
On 4 September 2015 at 21:46, Ray Stell <ste...@vt.edu> 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
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 <ste...@vt.edu> wrote:
This doc specifies to initdb with the admin user "postgres,"
http://bdr-project
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
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
Two comments on the BDR docs:
The second option provided here,
http://bdr-project.org/docs/stable/installation-source.html#INSTALLATION-SOURCE-PREREQS
"3.3.2.2 Downloading release source tarballs," seems to be an endless
loop between http://bdr-project.org/ and
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 Oct 9, 2014, at 4:30 PM, Rob Flemming robf...@gmail.com 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
On Aug 6, 2014, at 6:56 PM, Frank Pinto fr...@ayalo.co 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
On Aug 6, 2014, at 12:28 PM, Bill Epstein epste...@us.ibm.com wrote:
I'm very new to Postgres, but have plenty of experience developing stored
procs in Oracle.
I found this helpful:
On Jun 5, 2014, at 3:24 PM, john.tiger john.tigernas...@gmail.com wrote:
okay, figure this is a problem with postgresql user vs linux user - but how
to fix ?
John,
su and sudo are OS commands and the examples you provide using them demonstrate
attempts to start a shell as the postgres, OS
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 franc...@teksol.info 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
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:
On Jan 17, 2014, at 5:07 AM, Granthana Biswas granth...@zedo.com 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.
On Sep 23, 2013, at 11:20 AM, John DeSoi de...@pgedit.com 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
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 standby.
On Sep 17, 2013, at 7:22 AM, Echlin, Jamie (KFIA 611)
jamie.ech...@credit-suisse.com 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 j...@tanga.com 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
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, does not get carried to a -U flag
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
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:
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
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
CHECKPOINT
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 need to
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
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 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
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+certificationie=utf-8oe=utf-8aq=trls=org.mozilla:en-US:officialclient=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.
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
a
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
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
streaming replication?
yes
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
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|
setting
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
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 changes
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+
[user] [privs] /[ ROLE who granted privs.
What's the logic
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 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 want
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
On Wed, Feb 09, 2011 at 01:14:05AM -0600, Ogden wrote:
Thank you for letting me know about pg_controldata. I have been playing
around with this tool.
really interesting event/failure last night for me. I started a new
thread on the failure in the admin list. my streaming rep without
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
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 confusion - Archiving wal does not conflict in any way
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?
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 postgresql/pg_hba.conf with 9
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 in
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 connection.
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 enough.
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 do I get
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/postgresql.*
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? I've never
On Tue, Aug 17, 2010 at 11:02:20AM +0700, tuanhoanganh wrote:
On Sat, Aug 14, 2010 at 10:00 AM, tuanhoanganh hatua...@gmail.com 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
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
On Thu, Nov 19, 2009 at 10:43:57AM -0500, Ray Stell wrote:
Is there a doc that covers planning disk storage of indices?
http://www.postgresql.org/docs/8.4/interactive/storage-page-layout.html#FTN.AEN82952
53.5. Database Page Layout
http://archives.postgresql.org/pgsql-docs/2002-04/msg3.php
Is there a doc that covers planning disk storage of indices?
--
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, 2009 at 01:03:43PM -0700, Sergey Samokhin wrote:
Is there a way to disconnect all the clients as if the server has
crashed? It should look like a real crash from the client's point of
view.
ifconfig ethx down ?
--
Sent via pgsql-general mailing list
On Fri, Aug 07, 2009 at 01:54:47PM -0600, Scott Marlowe wrote:
You're probably better off switching to explicitly backing up
databases in the custom format and using a single pg_dumpall --globals
to backup the users accounts and such.
-g
--globals-only
Dump only global objects (roles
On Wed, Jul 29, 2009 at 09:05:37AM -0400, mzh...@ilww.com wrote:
Caused by: org.postgresql.util.PSQLException: PANIC: could not write to
log file 6, segment 176 at offset 14991360, length 8192: Read-only file
system
You need the sysadmin to examine the OS status. It's possible the system
On Tue, Jun 23, 2009 at 10:24:28AM -0400, Merlin Moncure wrote:
If you are
adventurous/enterprising, you could dig up the hot standby patch, get
it in line with the soon to be released 8.4, and play with it...it
works very well.
What is the entry point for source and config documentation of
On Tue, Jun 23, 2009 at 01:31:59PM -0400, Merlin Moncure wrote:
not sure what you mean by entry point? getting it running is a snap
if you've already ever done a warm standby setup. The hard part will
be patching it in.
In my case, I'd need to know where the patch can be downloaded and where
On Wed, Jun 03, 2009 at 08:13:48AM -0400, Geoffrey wrote:
I'm certainly looking at rsync rather then scp, which really makes more
sense.
You can mix ssh and rsync. The man pages has this example:
rsync -az -e ssh --delete ~ftp/pub/samba/ nimbus:~ftp/pub/tridge/samba
--
Sent via
On Wed, Mar 18, 2009 at 01:18:46AM -0700, Aaron Glenn wrote:
On Tue, Mar 17, 2009 at 11:27 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
start run it's course? for a 35GB+ database how long should I wait? is
there no way to log the status of what the postgres daemon is actually
doing
This is probably the wrong place to mention this, but idunno:
I did a search in the docs of pg_standby and was presented this link:
Based on your search term, we recommend the following links:
* http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/pg_standby/
but that link gives a
On Fri, Apr 11, 2008 at 04:48:03PM -0500, Erik Jones wrote:
On Apr 11, 2008, at 4:23 PM, Stefan Sturm wrote:
I don''t want to kill them. So how can I find out, what ist locking them?
Is there a tool, which shows me such Information?
There is a system catalog view called pg_locks that has an
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
$ cat /etc/issue
Red Hat Enterprise Linux AS release 3 (Taroon Update 9)
Kernel \r on an \m
$ rpm -qa | grep ssl
docbook-style-dsssl-1.76-8
mod_ssl-2.0.46-70.ent
On Wed, Feb 27, 2008 at 03:22:57PM -0500, Tom Lane wrote:
Ray Stell [EMAIL PROTECTED] writes:
How to get ssl configured on RHEL3? Can't seem to hook up
with openssl/ssl.h. This is 8.3.0 and it works on RHEL4:
Weird. Did you look into config.log to see exactly why the probes
for ssl.h
On Fri, Feb 15, 2008 at 10:21:16PM +0800, Phoenix Kiula wrote:
http://ogasawalrus.com/blog/node/462
Reading more carefully
sounds like it was the first read to me.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
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
where does a 500 lb gorilla sit?
http://www.networkworld.com/news/2007/102307-mysql-to-get-injection-of.html?netht=102407dailynews1nladname=102407dailynews
The companies are in close contact, Axmark said. The Google engineer in
charge of its MySQL deployments spent several days at MySQL's
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 looking for
take a look inside the rpm and see what it installed:
rpm -ql rpmname
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
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
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
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 -d
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
On Wed, May 16, 2007 at 08:21:59AM -0700, bruce wrote:
hey.. .
can someone point me to the cmds that i'd use in order to see what databases
are created in my postgres app. i need to see what's here, and then i need
template1=# select datname, oid from pg_database;
datname | oid
On Sat, May 12, 2007 at 09:36:45AM -0400, Tom Allison wrote:
Meanwhile, can I just use pg_dumpall to pull from 8.1 and then reload
into 8.2?
http://www.postgresql.org/docs/faqs.FAQ.html#item3.6
---(end of broadcast)---
TIP 5: don't forget to
On Thu, May 03, 2007 at 02:12:12AM -0700, pumesh wrote:
may lost. So what should i do to make the backup continuously or during
these intervals.
http://www.postgresql.org/docs/8.2/interactive/continuous-archiving.html
---(end of broadcast)---
TIP
On Mon, Jan 29, 2007 at 01:27:19PM -0800, Karen Hill wrote:
there any worry in the community that oracle will begin to target
postgres like they're targeting mySQL?
I attended a big ora conference in 2006 and was a bit surprised to
observe the fact that ora corp keynote addresses did not even
a shell
http://en.wikipedia.org/wiki/Shell_%28computing%29
On Wed, Dec 20, 2006 at 10:59:05AM -0800, Bob Pawley wrote:
I haven't used the command lines previously having relied on PG Admin.
In the instructions -
Starting postmaster
Nothing can happen to a database unless the postmaster
One suggestion would be to not cross post to admin and general and answer
the question sent back to you on the admin list, but that's just me.
On Mon, Nov 27, 2006 at 04:59:22PM +0200, Doron Baranes wrote:
Hi,
I installed postgres 814 on solaris 10 using the following packages
On Fri, Nov 24, 2006 at 04:42:56PM -0500, Tom Lane wrote:
Surely that is not a correct tunnel setup ... you can't have both ends
being the same port number on the same machine. There Can Be Only One
process listening on a given port per machine.
I think he is refering the -L option of ssh
The large print giveth and the small print taketh away - Tom Waits
On Tue, Nov 21, 2006 at 10:34:28PM +0100, Magnus Hagander wrote:
I intended to read a thread I caught part of in Oct, so I went to the
archive: http://archives.postgresql.org/pgsql-general/
Seems most of the months
I was interested in going down that path. This thread seems to be sparc
oriented. How about on opteron? Will pg work on solaris10 without too
much stress?
isainfo -v
64-bit amd64 applications
sse3 sse2 sse fxsr amd_3dnowx amd_3dnow amd_mmx mmx cmov amd_sysc cx8
tsc fpu
32-bit
I find the following comment in dbt2 users guide: The test kit
currently only supports SAP DB but work is currently being done to
support PostgresSQL. In the source tree of dbt2-0.39 has the file
./README-POSTGRESQL. Is this the entry point doc that a postgresql
user should start with to begin
On Fri, Oct 20, 2006 at 10:56:09PM +0930, Shane Ambler wrote:
Someone in the thread mentioned having to clean up shared mem. I've had
to do this often with oracle:
root# ipcs
-- Shared Memory Segments
keyshmid owner perms bytes nattch status
On Thu, 19 Oct 2006 06:14:46 -0600, Rick Gigger wrote:
I think we've got it figure out though. We were able to patch up the
db enough to extract the data with some help from google and old postings
from Tom.
It would be really great if you put down the specifics of what you
googled/old
ls -l /
maybe /data is a symlink?
On Fri, Oct 06, 2006 at 07:10:12PM +0530, km wrote:
Hi all,
I have installed postgresql(8.1.4) data dir on a partition (/data) which
rests on a separate disk from OS disk. The install dir is default
(usr/local/pgsql).
Now when i use use pgbench with
On Sun, Oct 01, 2006 at 12:55:51PM +0200, MaXX wrote:
Pure speculation: are you sure you aren't vacuuming too agressively?
The DELETE waiting and SELECT waiting sound to me like they are waiting
for a lock that another vacuum is holding.
How would one determine the lock situation
is this what you mean?
testdb=# \d foo_view
View public.foo_view
Column | Type | Modifiers
+---+---
x | character varying(20) |
stuff | text |
y | character varying(20) |
View definition:
SELECT a.x,
fixed now:
* From: kynn ( at ) panix ( dot ) com
* To: pgsql-novice ( at ) postgresql ( dot ) org
* Subject: SQL for removing duplicates?
* Date: Tue, 13 Jun 2006 12:11:41 -0400 (EDT)
Hi. I'm stumped. I have a large table (about 8.5M records), let's
call it t, whose columns
100 matches
Mail list logo