With Appreciation,
Ryan
From: David G. Johnston
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 12:48 PM, Ryan Ma
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.
's, so it would be very convenient for us to achieve this.
>
>
> Best Regards,
>
> Errol U. Neal
>
>
> ---(end of broadcast)---
> TIP 5: Have you checked our extensive FAQ?
>
>http://www.
>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
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
-
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
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 duplicate
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 broad
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 manipul
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: pg_connec
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
If you are running on a dedicated postgres machine, run the command "top"
from the command line. The third and fourth line should read like:
CPU0 states: 0.0% user, 5.0% system, 0.0% nice, 94.0% idle
CPU1 states: 0.1% user, 0.0% system, 0.0% nice, 99.0% idle
(my system is idle now, but
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
There may be some errors in the script that's loads postgres at
startup. Look in the "/etc/rc.d/init/" directory and see if there is an
executable named postgres or something similar. If so, post the source of
this file to the group so we can take a look.
Good Luck!
-Ryan Ma
your postgresql.conf file (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.
Check
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 sugge
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
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 c
e 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 Dat
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 sta
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
t;questions" ("survey_id");
>
>
>User Answers:
>--
>CREATE TABLE "user_answers" (
>"ua_id" int8 DEFAULT nextval('ua_id_seq'::text) NOT NULL,
>"user_id" int8 NOT NULL,
>"question_id" int8 NOT NU
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 sto
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_ka
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 broadcast)---
26 matches
Mail list logo
