On 8/5/2017 6:06 PM, Dan Cooperstock at Software4Nonprofits wrote:
(I wish Postgres had a web-based community board,
rather than just this mailing list with no history available!) I will
post it to Appeon as an actual bug if I get stuck.
Have you looked here?
https://www.postgresql.org/list/
hundreds of web pages. It won't
help much with the first set of changes, but it will help with
portability later.
Rick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I was hopping that in a SELECT I could replace the data from the email
column to something else...
maybe email = name_first + name_last? Is that possible?
I can't overwrite the data into that column... that has to be done by
the select (if possible)
SELECT , , ..., name_first || ' ' || name_
Is there a way to identify ldap connections to pgsql 9.3 from log files?
Thanks,
Rick
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Do I need to vacuum after an alter table command?
Does it matter if there is a default or if we accept NULLs for the new
field?
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
this or run
into performance issues.
On Mon, Jun 22, 2015 at 1:06 PM, William Dunn wrote:
> Hello Rick,
>
> As I understand it you are correct. Oracle/DB2/Postgres and I think the
> SQL Standards to not implement constraints against tables on foreign
> servers. Although it wo
n reference table to either cascade
or stop the delete once I decide which I'd rather do.
Thanks for the help!
On Mon, Jun 22, 2015 at 12:21 PM, Tom Lane wrote:
> Rick Otten writes:
> > Hello pgsql-general,
> > I'd like to set up a foreign key constraint to a foreign tab
nt on using that
function, but I thought I'd as first if there was a better way.
Thanks.
--
Rick Otten
rottenwindf...@gmail.com
xpected in the SR only setup configuration case?
On Sun, Dec 18, 2011 at 9:51 PM, Fujii Masao wrote:
> On Fri, Dec 16, 2011 at 3:59 AM, Rick Pufky wrote:
> > Any thoughts on the above snippets? Am I interpreting the documentation
> > correctly? Is there any further information need
2740:FATAL: timeline 2 of the primary does
not match recovery target timeline 1
2011-12-15 12:08:52.323 EST2742:FATAL: timeline 2 of the primary does
not match recovery target timeline 1
... repeated continuously ...
Any thoughts on the above snippets? Am I interpreting the documentation
correctly? Is there any further information needed to debug this?
Thanks,
Rick
of this set"). It seems odd that this should work:
-- drop unique index
-- single update statement
-- apply unique index
But just "single update statement" won't.
--
Rick Genter
rick.gen...@gmail.com
mid. (And for 9.2, as I
understand it, q.mid as well, since I believe in 9.2 PostgreSQL will be able to
compute the result strictly from the indexes without hitting the base tables.)
--
Rick Genter
rick.gen...@gmail.com
l.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
; there are in the other tables.
>
> I am a bit perplexed by what is happening here.
>
> Cheers
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
On Thu, Jul 7, 2011 at 10:26 AM, Dave Coventry wrote:
> Hi Rick,
>
> Thanks for the response.
>
> What is "the sequence"? and how do I grant the privileges needed to
> insert data into the database?
>
> Is it a postgres issue?
>
Yes. I don't know drup
> Can anyone suggest a way forward?
>
>From the message I'd say that the drupal user doesn't have access to the
sequence, which is a separate object from the table.
--
Rick Genter
rick.gen...@gmail.com
.4. The semicolon is required.
On Tue, Jun 28, 2011 at 3:53 PM, Rich Shepard wrote:
> On Tue, 28 Jun 2011, Rick Genter wrote:
>
> Silly question, but did you try it with a semicolon after the drop table?
>>
>
> Rick,
>
> See my answer to Andy: that's incorrect sy
a pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>
--
Rick Genter
rick.gen...@gmail.com
clear.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Rick Genter
rick.gen...@gmail.com
On Tue, 14 Jun 2011, Tom Lane wrote:
> Rick Harding writes:
> > CREATE OR REPLACE FUNCTION mysum(curr integer, vals group_data)
> > RETURNS integer
> > AS $$
> > try:
> > curr = curr + vals['weight']
> > except Un
T: PL/Python function "mysum"
-- NOTICE: UNBOUND
-- CONTEXT: PL/Python function "mysum"
mysumagg
--
0
(1 row)
Thanks for any pointers on what I'm missing from the way to handle the
agggregate definition.
--
Rick Harding
@mitechie
http://blog.mitechie.com
is should return a recordset where each row has one column which is the
result of regex_replace() on the corresponding row of table.
--
Rick Genter
rick.gen...@gmail.com
> any difference. If
> I leave out the old alias, it complains about the columns being ambiguous.
> How should the query above be changed to be syntactically correct?
>
> Thanks,
> Andy
>
--
Rick Genter
rick.gen...@gmail.com
you can add 360 degrees to a long and get a value that should continue to
work. So, assuming "West" is negative, -175 (175 degrees West) is the same
as -175+360 = 185 (185 degrees East). Then you don't have to worry about
wraparound. If the result is > 180, subtract 360.
--
Rick Genter
rick.gen...@gmail.com
ate for a "hacker list".
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
QL30'. Object reference not set to an instance of an object.
(Microsoft.DataWarehouse)'
If I select 'SQL Command' as the Data Access mode, and enter any SQL Command
(eg select * from PostgresTable) and hit the Preview button, the expected data
is returned.
My question is why can it not return t
On May 16, 2011, at 10:31 PM, Adarsh Sharma wrote:
> Rick Genter wrote:
>>
>> On May 16, 2011, at 10:09 PM, Adarsh Sharma wrote:
>>
>>
>>> Dear all,
>>>
>>> I need to research on Memcache in the next few days.
>>>
>>&
#x27;s not the OLTP just a simple OLAP
> where data is fetched and stored in some meaningful format.
>
>
> What are benefits & why we used memcahed?
>
> What are the bottlenecks to meet?
You need to read about memcached. Memcached is not something you "enable&
lieve that this accomplishes the goal (increasing available drive space)
with a minimum amount of down time. Am I thinking correctly, or have I
missed something?
--
Rick Genter
rick.gen...@gmail.com
sers EXECUTE access to the functions. The functions run
as the user that created them, so they will have direct INSERT/UPDATE/DELETE
access to the tables while your regular users won't.
--
Rick Genter
rick.gen...@gmail.com
.
>
So your data is denormalized? (The "category" appears in 2 tables?) Don't do
that. Create a view that joins your two tables together instead if you need
a single entity that contains data from multiple sources. Then you won't
have any of the data integrity issues you
On Thu, 2011-05-05 at 15:05 -0400, jtke...@verizon.net wrote:
> Im trying to connect my WS to a postgresql database (destination) via
> a middle server
> I.e.
> WS > Middle > Database
> server server
> 172.x.2.4 172.x.4.12
>
>
> I can crea
u can't update achievement_attempt_id in
the achievement_attempt table if there is an achievement_attempt_actions
record that refers to it since that would break the reference. (Not that you
want to be updating primary key values in the first place...)
--
Rick Genter
rick.gen...@gmail.com
On May 2, 2011, at 10:52 PM, Craig Ringer wrote:
> SSN? What if they don't live in the US or aren't a citizen?
Non-citizens can have SSNs (they have to if they work in the US).
--
Rick Genter
rick.gen...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql
Does ‘minute from interval’ only accept string literals?
>
>
>
> Thanks,
>
> Adam
>
>
>
> Adam Bruss
>
> Development Engineer
>
> AWR Corporation/Simulation Technology & Applied Research
>
> 11520 N. Port Washington Rd., Suite 201
>
> Mequon, WI 5
isco group
where the last update/meeting was 2 years ago. Is there such a group in this
area? Thanks.
--
Rick Genter
rick.gen...@gmail.com
I think an intro presentation for Oracle developers should include:
-- sqlplus to psql comparison
-- how to setup OS authenticated users in PostgreSQL
-- purpose of pg_hba.conf
-- schemas and search_path.
-- where to find things in the catalog. information_schema or pg_tables
Rick
quot; specified in USING clause does not exist in
left table
I am rather mystified by this, since this field is definitely in the
dnasample table, as the primary key. Nor do not see how to start debugging
such an error. Any suggestions appreciated...
--Rick
--
Sent via pgsql-general mail
int is too difficult to express in SQL, and just rely on the
business logic never being wrong. I was hoping that wasn't the case :)
Thanks,
-Rick-
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
restore.exe : pg_restore: implied data-only restore
At line:1 char:2
+ & <<<< 'C:\Program Files (x86)\PostgreSQL\8.4\bin\pg_restore.exe' -v
--use-list=backup.list -U blahblah -p -C backup.db
+ CategoryInfo : NotSpecified: (pg_restore: implied data-only
Thanks Dim; I was not aware of pgloader. This, and the other suggestions,
have helped a lot; thanks everyone.
--rick
On Mon, Mar 29, 2010 at 7:41 AM, Dimitri Fontaine wrote:
> Rick Casey writes:
>
> > So, I am wondering if there is any to optimize this process? I have been
> usi
erely,
Rick
Details of the code follow:
Here is the basic COPY command, which I run as the postgres user, to import
the CSV files:
COPY allcalls FROM '/data/allcalls-csv/sub3ab' WITH CSV;
Here is what some sample data look like in the files:
3153371867,2008-02-04 16:11:00,1009,1,40
212
You can get extra (undesirable) results, depending on the name. For
example, if you are searching for the last name of "Ricks", you will also
find all authors whose first name is "Rick".
I also noticed that the directions for indexing multiple columns don't seem
to be
I want to be able to search a list of articles for title words as well as
author names. I understand how to do the title words with the full text
searching. But I'm not sure the best strategy for the names. The full text
parser "parses" the names giving undesirable results.
For example,
select
Definitely believable. It gives me an internal avenue to chase down.
Thanks
--Rick
Alvaro Herrera wrote:
Rick Weber wrote:
While working on tuning my database, I was experimenting with changing
the wal_sync_method to try to find the optimal value. The really odd
thing is when I
throughput, but nothing
indicating that O_SYNC doesn't work.
Can anybody provide me any pointers on this?
Thanks
--Rick
smime.p7s
Description: S/MIME Cryptographic Signature
In article <[EMAIL PROTECTED]>,
Sam Mason <[EMAIL PROTECTED]> wrote:
>I'm not quite sure if this would help your use case, but a few editors
>allow you to send blocks of text to other processes. For example, under
>Emacs I can hit Ctrl+C twice and it will grab the current paragraph
>and send it o
Steve Crawford wrote:
BTW, why not upgrade to the latest version?
Cheers,
Steve
Mostly because its not my server :-) I've suggested that, we'll see.
I appreciate the comments regarding type casting. I'll be sure to look
out for that.
---(end of broadcast)
Tom Lane wrote:
Rick Schumeyer <[EMAIL PROTECTED]> writes:
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care
I'm working with someone who is about to upgrade from (I believe) pg 7.4
to pg 8.1.
What would be the best resource to read to look for "gotchas"? Release
notes? At the moment, we don't care about performance problems, only
things that might break.
---(end of broa
We are looking for a Postgresql Architect/Developer to do some mentoring,
training, knowledge transfer and implementation for a large media outlet in
Los Angeles. Travel is fully funded and the rates are great! Please reply
to [EMAIL PROTECTED] Thank you for your time!!!
Regards,
Ricky G
I've read the earlier threads on whether to store images in the database
or filesystem. I think I understand the pros and cons of each method,
but I have a question on a specific use case.
Let's say I have a web app, and I want to display the images in a web page.
a) if the images are in the
I'm developing an application that will be used by several independent
customers. Conceptually, the data from one customer has no relation at
all to another customer. In fact, each customer's data is private, and
you would never combine data from different customers. I'm trying to
decide whe
other
sequences that are contained in my database and it appears that my
permissions are ok.
Does anyone have any suggestions for any other settings I should verify?
Thanks in advance.
Rick Hackenberg
Business Systems Analyst
PRIMEDIA
Enthusiast Media
6405 Flank Drive
Harrisburg, PA 17112
717-540
When you say "reconfigure db" does this mean "recreate all your tsearch
indexes"?
Joshua D. Drake wrote:
Rick Schumeyer wrote:
I have a database running under pg 8.1.4 that uses tsearch2. I am
upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
install i
I have a database running under pg 8.1.4 that uses tsearch2. I am
upgrading to pg 8.2.4. I dumped the pg 8.1.x database and tried to
install it in pg 8.2.4. This does not seem to work.
Is there a procedure for this that someone can point me to?
---(end of broadcast)-
Actually, the situation is slightly more complicated. It's more like I
have tables A1, A2, and A3 each of which must have a corresponding row
in B. So each of A1, A2 and A3 has a BEFORE INSERT trigger that creates
a row in B and sets a FK in A1 (or A2 or A3). So I can't just use the
same PK
trigger, since it does not receive a result from the
database...until reload is called.
At least I assume that is correct.
Michael Glaesemann wrote:
On May 22, 2007, at 21:21 , Rick Schumeyer wrote:
The problem is that the new A object that rails gets does not see the
effect of the trigger
I'm using Ruby on Rails and have two tables, A and B. Every row in A
needs a corresponding row in B. A also contains a FK pointing to B.
I created a before insert trigger on A that inserts a new row in B, and
sets the FK in A. This seems to be running fine.
The problem is that the new A ob
Has anyone here used a postgres array with Rails? If so, how?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
I'm writing an article based on my experience setting up a ruby-on-rails
server for a web apps class I'm teaching. My target audience is people
who have a clue,
but are not gurus at the wide collection of software necessary to get a
server running.
The in-work article is at http://www.schumey
I'm developing a system using Ruby on Rails (with ActiveRecord) and
postgres. (Although I think my question is still relevant for, say,
java with hibernate.)
I have two classes (tables): users and employees. A user is an account
that can logon to the system, while an employee is...umm...an
This may be bad design on my part, but...
I have three tables of interest...Account, Employee, and
AccountEmployeeRelation. There is a many-to-many relationship between
accounts and employees. The join table also contains a column
indicating what role the employee plays on this account.
My
load the result of
running pgdump on the 8.1 database, and ignore the errors?
Oleg Bartunov wrote:
Rick,
did you load tsearch2 itself into your database ?
Oleg
On Thu, 7 Dec 2006, Rick Schumeyer wrote:
I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.
All I did to
I am trying to copy a database that uses tsearch2 from pg8.1 to pg8.2.
All I did to install tsearch2 was cd to the contrib/tsearch2 directory,
then make, make install.
I then dumped the database from pg8.1 and used psql -f filename db to
load in into pg8.2.
Attempting a query gives an error
Thanks for the suggestion...it needed only one small change:
update tsubset set k = t.k from t where t.f=tsubset.f;
Thanks!
Alban Hertroys wrote:
Rick Schumeyer wrote:
foreach f in tsubset
update tsubset set k=(select k from t, tsubset where t.f=f);
end
Can this be done with one SQL
I think this can be done with one SQL statement, but I'm not sure.
I have two tables: table t contains key k, another field f, and a bunch
of other stuff.
In a poor design decision, table tsubset contains a small number of
"pointers" to t. I should have used the k column; instead I used the
Albe Laurenz wrote:
My database locale is en_US, and by default my databases are UTF8.
My application code allows the user to paste text into a box and
submit
it to the database. Sometimes the pasted text contains non UTF8
characters, typically the "fancy" forms of quotes and apostr
My database locale is en_US, and by default my databases are UTF8.
My application code allows the user to paste text into a box and submit
it to the database. Sometimes the pasted text contains non UTF8
characters, typically the "fancy" forms of quotes and apostrophes. The
database does not
I am transferring a database from a system where I am a pg superuser to
one where I am not.
The database uses tsearch2. I am unable to install any of the
functions. For example:
CREATE FUNCTION gtsvector_in(cstring) RETURNS gtsvector
AS '$libdir/tsearch2', 'gtsvector_in'
LANGUAGE c ST
n OWNER TO rick;
The user 'rick' does not exist on the target system. I've looked at the
help for pg_dump...it looks like specifying "no-owner" will skip these
lines. Are there any side effects I need to be aware of?
The second problem is the statement:
CREATE PROCEDU
I confess to having once written code that prints something like
"Items # 1 to 10 of 45"
by using select count(*) from t where condition; and select * from t
where condition limit 10 offset x;
I now know this is "bad", I guess because of the count() and the offset.
So what is the preferred way
Rick Gigger <[EMAIL PROTECTED]> writes:
To make a long story short lets just say that I had a bit of a
hardware failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to say it's totally hosed or is there some
chance of reco
Ray Stell wrote:
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 w
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/19/06 00:46, Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
On 10/18/06 19:57, Rick Gigger wrote:
[snip]
Not much that is useful. I think this is a
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 23:52, Rick Gigger wrote:
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a
Rick Gigger wrote:
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data
Ron Johnson wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 10/18/06 19:57, Rick Gigger wrote:
To make a long story short lets just say that I had a bit of a hardware
failure recently.
If I got an error like this when trying to dump a db from the mangled
data directory is it safe to
ic.file (vfs_id, vfs_type,
vfs_path, vfs_name, vfs_modified, vfs_owner, vfs_data) TO stdout;
Thanks,
Rick
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
mandprompt...my initial guess is they do not support
my*** ?
-Original Message-
From: Joshua D. Drake [mailto:[EMAIL PROTECTED]
Sent: Friday, September 29, 2006 5:05 PM
To: Rick Schumeyer
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pg web hosting with tsearch2?
Rick Schumeyer
I hope pg-general is the correct forum for this question…if
not please let me know the correct location.
I have a pg application that uses tsearch2. I would
like to move this application off my local machine and onto a web host
somewhere. I have some questions regarding this:
1)
had to identify what the bad chars were. I think that viewing the
dump in vi showed me the hex codes for the non-ascii chars. Then I
changed the encoding specified at the top of the dump as LATIN1. Then I
used sed to remove them as I piped it into a postgres unicode db.
Rick
-
In article <[EMAIL PROTECTED]>,
Devrim GUNDUZ <[EMAIL PROTECTED]> wrote:
>Create the user again with the same userid (I mean revert what you did).
>You can get this info from pg_tables and pg_authid(or pg_shadow,
>depending on your PostgreSQL version).
It turned out to be some tables had been cre
I did something foolish and now I'm getting warnings every time
pg_dump runs (hourly from cron). Anybody have a suggestion on how
to fix this?
pg_dump: WARNING: owner of data type "accountuser" appears to be invalid
pg_dump: WARNING: owner of data type "adminuser" appears to be invalid
pg_dump: WA
In article <[EMAIL PROTECTED]>,
Marc G. Fournier <[EMAIL PROTECTED]> wrote:
>So how did you get this message? :(
Via Usenet.
--
http://yosemitephotos.net/
---(end of broadcast)---
TIP 6: explain analyze is your friend
In article <[EMAIL PROTECTED]>,
Roman Neuhauser <[EMAIL PROTECTED]> wrote:
>I've been waiting five months for the majordomo moderators to approve
>my subscription requests to several @postgresql.org mailing lists.
I stopped getting any mail from postgresql.org last fall. Repeated
attempts to subs
affected, but a vacuum run through psql yes.
You can also set it for a user (see "alter user ... set ..."), and use
separate users for application access and maintenance work.
Cheers,
Csaba.
On Fri, 2006-03-03 at 11:03, Rick Gigger wrote:
Oh that will abort vacuum after that time as well?
eries only when I specify. But if it kills vacuum I
will have to take a different approach.
On Mar 3, 2006, at 2:59 AM, Ragnar wrote:
On fim, 2006-03-02 at 11:03 -0700, Rick Gigger wrote:
Never-mind that. I'm assuming statement_timeout is what I need?
Yes, but take care if you chan
Never-mind that. I'm assuming statement_timeout is what I need?
On Mar 2, 2006, at 11:01 AM, Rick Gigger wrote:
Is there a way to put a timeout on a query so that if it runs
longer than 5 minutes or something it is just automatically
terminated?
---(e
Is there a way to put a timeout on a query so that if it runs longer
than 5 minutes or something it is just automatically terminated?
---(end of broadcast)---
TIP 6: explain analyze is your friend
I have this exact problem. I have dumped and reloaded other
databases and set the client encoding to convert them to UTF-8 but I
have one database with values that still cause it to fail, even if I
specify that the client encoding is SQL_ASCII. How do I fix that?
On Feb 17, 2006, at 4:08
mysql has anything to offer here. They just
handle all of the cases. Even the ones that shouldn't work.
Rick
On Feb 15, 2006, at 10:39 PM, Tom Lane wrote:
Chris <[EMAIL PROTECTED]> writes:
Quick test:
create table a(a int primary key, b int, c varchar(200));
insert into
they try to buy off all of their employees individually).
Of course they should all just switch to postgres anyway but that is
another story. :)
Rick
On Feb 15, 2006, at 10:05 AM, Chad wrote:
I am not concerned about Sleepycat revoking their open source license
for future versions of BDB.
time to fill up.
Anyway I would have been less confused if the docs had made it more
clear that the name of the stop wal file was in the backup history file.
Rick
On Jan 30, 2006, at 10:20 PM, Bruce Momjian wrote:
Yes, I think copying it while it is being written is safe.
Is the ordering guaranteed to be the same on both boxes if you do this?
Rick
On Feb 9, 2006, at 1:03 PM, Philippe Ferreira wrote:
Are there any tools that can compare a database schema, and
produce sql of the changes from one version to the next.
We have a development server, and it
n a single
transaction in postgres it may not matter whether you do them
individually or batched like that.
If you really have a lot of data you want to insert at once why not
just use COPY?
Rick
On Feb 9, 2006, at 4:13 PM, Chris wrote:
Hi,
You can't do that in postgres, sorry. Tha
slave and sta rt it up.
Again, see the directions for incremental backup.
http://www.postgresql.org/docs/8.1/interactive/backup-online.html
Rick
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresq
l be moved to
stable soon.
Rick
On Jan 31, 2006, at 8:58 AM, Andrus wrote:
How to install Postgres 8.1 on PowerMac 10.1, OS X 10.4.4 ?
Is there ready made binaries available for download of should I
build from
source ?
Where are installing or building instructions for Mac available
Nagios and snmp
http://www.nagios.org/
On Jan 31, 2006, at 9:06 AM, Henrique Engelmann wrote:
Hi,
We´ve many postgresql servers running in linux Redhat/Fedora boxes
in our enterprise and we´re looking for some tool to help us to
administer and monitor those systems. This tool should monit
1 - 100 of 211 matches
Mail list logo
