).
With Appreciation,
Ryan
From: David G. Johnston <david.g.johns...@gmail.com>
Sent: Tuesday, November 8, 2016 3:19:02 PM
To: Ryan Mahoney
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Running on Docker, AWS with Data Stored on EBS
On Tue, Nov 8, 2016 at
Hi All,
TL;TR: Can a new PostgreSQL process, running on a different server instance
effectively resume operations by reading the same data directory location as
another PostgreSQL process that is no longer running?
- - -
I have an application that is deployed to AWS as a docker container.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
--
Ryan Mahoney [EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't
in this direction as well as who else may be interested in this
project. Although I only occasionally chime in, I read the general and
hackers lists daily (er, hourly ;) ) and have a deep respect for the
individuals who participate on these lists.
Looking forward to your feedback,
Ryan Mahoney
BTW, I have
postgresql.com takes you to greatbridge.com as of today - did it always -
or am I losing my mind?
-r
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
The website is currently undergoing a rewrite.
Vince.
Are there architectural designs, use cases, mock-ups, color schemes,
requirements, etc. that we can view online so we can understand the
direction things are moving in and offer our input and talents? If this
project is worked on by a
What does your data look like? If you have a lot of duplicate id's, a
sequential scan may be better than an index scan.
If you are not sure if this is the case, try:
SELECT id, count(*) AS count FROM test GROUP BY id ORDER BY count DESC
LIMIT 50;
This should show you the top 50 most
SELECT datname FROM pg_database WHERE datname NOT LIKE 'template_';
-r
At 04:22 PM 7/30/01 -0400, Peter Choe wrote:
how do i get the names of the databases that are created in postgres?
is there a select statement similar to oracle?
peter choe
---(end of
I think you should look into the documentation for your particular
interface. We generally use PHP as an interface. We use the pg_exec
function to create an indexed result set from a connection and
statement. Then we iterate through each indexed row, calling
pg_fetch_array so we can
Call phpinfo() and see if you have postgres support compiled into
php. This would cause your error.
Good Luck!
-r
At 04:13 PM 7/26/01 +1200, Mike C wrote:
Hello,
Err message within a
browser(http://its-macman.otago.ac.nz/~mike/index.php) =
Fatal error: Call to
undefined function:
Possibly. If your OS does not support or is not currently configured for
dual processor utilization, then your machine will not use the other
CPU. What OS/Version are you running?
-r
At 04:31 PM 7/23/01 -0500, Jack Long wrote:
uh-oh, top looks like this for me:
3:35pm up 43 min, 3
http://www.greatbridge.org/genpage?replication_top
All you could ever want to know about pgsql replication.
God Luck!
-r
At 04:31 PM 7/18/01 -0400, Fran Fabrizio wrote:
Does postgres support replication? I think this is the feature I need.
I have a table in one db that I need to use from
(usually
located in /usr/local/pgsql/data/postgresql.conf). Your Connection
Parameters section should read like this:
#
# Connection Parameters
#
tcpip_socket = true
#ssl = false
Good Luck!
-Ryan Mahoney
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system
In my logs, I find a lot of these:
NOTICE: current transaction is aborted, queries ignored until end of
transaction block
should I be concerned? Is there a place where I can read about the
difference messages that may appear in the log file?
Thanks!
- Ryan Mahoney
---
Outgoing
Hi Mark, This is being worked on now. I believe the 7.2 release will have
enable you to run a vacuum with no downtime.
-r
At 03:39 PM 7/11/01 -0600, Mark wrote:
Is Postgresql ready for 24/7 uptime? Our tests have shown that vacuumdb
requires downtime, and if one does this nightly as
Read the message archives ;)
-r
At 06:30 PM 7/7/01 +, Dr. Evil wrote:
I saw an announcement somewhere that RedHat is working on its own Open
Database, based on PG. What do people think about this?
---(end of broadcast)---
TIP 2: you can
the market to ensure it's
place in the industry today and in the future.
-Ryan Mahoney
CTO Payment Alliance, Inc.
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
I don't know the cause, but if you only have to run this procedure once in
a while, you could select all the records that need to be updated, and use
a text editor to build a few thousand single update statement, then save
this file and echo it to the postgres backend through psql.
Good Luck!
I have never had the postmaster die on me, although I have made is slow to
almost a halt ;)
Performance really depends what your doing. It is possible to write a
query that uses all system resources.
I recommend restarting postgres and take a look at the CPU utilization and
make sure at
This is a guess - have you tried:
SELECT * FROM tableName WHERE time = CURRENT_TIMESTAMP - '3
months'::interval
let me know if it works!
-r
At 05:49 PM 5/15/01 +0900, hiroko wrote:
hi all.
from a DB table, I'd like to SELECT out the date of 3months
before.
the command should be
= select *
If your query is not using the correct index files, you're query will run
slowly. Please post the output from EXPLAIN.
-r
At 09:00 PM 5/15/01 +0200, snpe wrote:
On Tuesday 15 May 2001 17:28, Stephan Szabo wrote:
On Tue, 15 May 2001, snpe wrote:
Table e_kalkn have 4668 rows and e_kalkns
Please post the sql statement that creates these tables.
-r
At 12:15 AM 5/16/01 -0400, Alex Hochberger wrote:
To any SQL wizards out there,
I have finally exhausted my SQL knowledge.
I have 3 tables that I need to do a fancy join on...
1 stores the users
1 stores the questions
1 stores the
these questions will be for survey 1...
Alex
-Original Message-
From: Ryan Mahoney [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 7:22 PM
To: Alex Hochberger; '[EMAIL PROTECTED]'
Subject: Re: [GENERAL] SQL help...
Please post the sql statement that creates
Is it possible to view the last 100 queries issued to the database?
-r
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.251 / Virus Database: 124 - Release Date: 4/26/01
---(end of
24 matches
Mail list logo
