Hello PG Experts!
I have restored a Database Cluster with a recovery_target_time set to
recovery_target_time = '2013-07-27 21:20:17.127664+00'
recovery_target_inclusive = false
now it seems the restore rather restored to some point in time (rather the
18th than the 27th). Is there an explanati
Klaus Ita wrote:
> I have restored a Database Cluster with a recovery_target_time set to
>
> recovery_target_time = '2013-07-27 21:20:17.127664+00'
> recovery_target_inclusive = false
>
>
>
> now it seems the restore rather restored to some point in time (rather the
> 18th than the 27th). Is
Dear list,
Section 9.8 of the postgres (9.1) documentation says, on the
patterns for to_char(timestamp, pattern),:
J Julian Day (days since November 24, 4714 BC at midnight)
This leaves open the question of what's actually returned. At least
in astronomy, it is customary to have fractiona
Hi Adrian
Thanks for getting back to me so soon!
1) Yes, I downloaded postgresql-9.2.4-1-windows.exe one click installer from
the EDB web page. I see the page format has changed a little recently, but
it is still the same file.
2) No, I have only ever tried to installed version 9.2
3) Yes -though
On Jul 31, 2013, at 7:13, Tom Lane wrote:
> Jeff Janes writes:
>> On Tuesday, July 30, 2013, James Sewell wrote:
>>> I understand what you are saying, and I understand how the backup_label
>>> works - but I still don't understand why the pg_start and pg_stop commands
>>> are REQUIRED when doing
On Jul 31, 2013, at 12:07, "Stephen Brearley" wrote:
> Both the install and uninstall should work flawlessly. The only thing I can
> see is that I have installed the program once before, and I have put my data
> on my d: drive to separate it from the program in case of software problems,
> but I
Hi Thomas
**Thanks for getting back to me**
In answer to your points:
1) I could not get Postgresql to run correctly, so I assumed it could
be a bug. I checked the documentation for bug reports, and this seemed to
suggest that anything that appears to be a bug should be reported. I
Hi George
Apologies to be rather grumpy, but I have been waiting a long time to get a
glimmer of help!! Feeling a bit more positive now.
Thanks for coming back with more specifics. I haven't done anything since
your last email, as I have tried many times before what you (generally)
suggeste
Hi Raghu
Thanks for offering to help, but I don't have Skype, as I am concerned about
security issues. There seem to be some other companies out there which offer
a similar service, but I haven't yet determined which would best suit. I'm
getting nagged from friends about this too..
Any thou
Alban Hertroys writes:
> That begs the question what happens in case of a crash or (worse) a partial
> crash when multiple file systems are involved.
As long as the OS+hardware honors the contract of fsync(), everything's
fine. If the storage system loses data that it claims to have fsync'd to
On Jul 31, 2013, at 14:07, "Stephen Brearley" wrote:
> Hi Alban
>
> Much thanks for getting back to me!
>
> The event file gets written to (as attached):
> C:\Users\SDB\AppData\Local\Temp
That's the installation log, not the postgres log.
I suspect the postgres log is either in the Windows Eve
Hi Stephen,
As per my experience, installing postgresql on windows machine automatically
create postgres user. When you uninstall it, the postgres user doesn't
automatically removed, you must remove it manually.
So, when you install postgres for the second time, it will use existing
postgres u
On Sat, Jul 27, 2013 at 10:34 PM, Janek Sendrowski wrote:
> Hi Sergey Konoplev,
>
> If I'm searching for a sentence like "The tiger is the largest cat
> species" for example.
>
> I can only find the sentences, which include the words "tiger, largest,
> cat, species", but I also like to have the s
I am sorry, I just re-read your mail and realized you have already tried
with pg_trgm.
On Wed, Jul 31, 2013 at 7:23 PM, Beena Emerson wrote:
> On Sat, Jul 27, 2013 at 10:34 PM, Janek Sendrowski wrote:
>
>> Hi Sergey Konoplev,
>>
>> If I'm searching for a sentence like "The tiger is the larges
On 07/31/2013 04:28 AM, Stephen Brearley wrote:
Hi Thomas
**Thanks for getting back to me**
I would not normally do anything in the Registry, as I am aware that is
asking for trouble. However, I hadn’t noted that I could specify a data
location on my original install, so I checked the web and
2013-07-30 11:15:15 UTC <%> LOG: starting point-in-time recovery to
2013-07-27 21:20:17.127664+00
2013-07-30 11:15:15 UTC <%> LOG: restored log file
"00010230005C" from archive
2013-07-30 11:15:15 UTC <%> LOG: restored log file
"00010230005A" from archive
2013-07-30 11:15
On 07/30/2013 08:25 PM, Adrian Klaver wrote:
On 07/30/2013 07:15 PM, Rob Sargent wrote:
I'm not getting the xml2 and uuid-ossp control files delivered to the
extension directory
I've moved to a CentOS box (and dropped pam):
cat /etc/system-release
CentOS release 6.4 (Final)
uname -a
Linux co-a
On 07/31/2013 08:08 AM, Rob Sargent wrote:
On 07/30/2013 08:25 PM, Adrian Klaver wrote:
http://www.postgresql.org/docs/9.3/static/install-procedure.html
If you built the world above, type instead:
gmake install-world
This also installs the documentation.
rjs
Yes. Of course. INST
Any interest out there in having the table named before the re-index begins?
Now we see 'NOTICE: table "pg_catalog.pg_db_role_setting" was reindexed'
I would rather see 'NOTICE: reindexing table
"pg_catalog.pg_db_role_setting"'
When the output stalls on a larger table, I would like to know w
Hi,
I got this page by accident trying find more info on tests EnterpriseDB did
with PostgressSQL Power Linux.
Anyway as I work IBM Power sales rep for Finland myself, please sent me
little bit more info on what kind of test you have in mind. (Do you just
want few core's to test it works / or bi
I have two postgres instances each with a database of same schema. The
dataset in both is ''same'' but for randomness i.e. both contain two
tables pc(did) and tc(pid, did) that have almost
same number of rows and have been generate from same distribution.
However the query plan for the join turn
Hello
do you have same configuration?
Regards
Pavel
2013/7/31 Sandeep Gupta :
> I have two postgres instances each with a database of same schema. The
> dataset in both is ''same'' but for randomness i.e. both contain two tables
> pc(did) and tc(pid, did) that have almost
> same number of row
Hi Pavel,
Yes. The postgresql.conf is exactly the same. The have the same index and
clustering and are on the same compute node as well but running on
different ports.
-Sandeep
On Wed, Jul 31, 2013 at 3:14 PM, Pavel Stehule wrote:
> Hello
>
> do you have same configuration?
>
> Regards
>
>
details regarding buffer usage:
for database 1:
QUERY
PLAN
---
Aggregate (cos
Sandeep Gupta writes:
> details regarding buffer usage:
> [ 100% buffer hit rate ]
Your database is evidently fully cached in memory. If that's the
operating mode you expect, you need to change the planner's cost
parameters, in particular reduce random_page_cost to equal seq_page_cost.
There is
I have about 20 functions that all accept integer value inputs.
I want to have views which call these functions using various SUMs of
integers e.g.
select myfunction(sum(foo), sum(bar)) where foo and bar are integer types.
This doesn't really work, you get:
ERROR: function aggregates.stat_avg(
Wells Oliver-2 wrote
> I have about 20 functions that all accept integer value inputs.
>
> I want to have views which call these functions using various SUMs of
> integers e.g.
>
> select myfunction(sum(foo), sum(bar)) where foo and bar are integer types.
>
> This doesn't really work, you get:
>
27 matches
Mail list logo
