Garry Saddington wrote:
Does anyone know of a web based accounting(finance) package that uses
Postgresql as a backend?
LedgerSMB http://www.ledgersmb.org
Rod
--
Thanks Garry
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
Christine Penner wrote:
Hi,
I'm having trouble getting a connection to Postgres to work from outside
of my local network. It was working fine at one point. Then I had to
change IP addresses and I can't get it to work. This is what I've done.
On the computer with Postgres installed I have
Craig Ringer wrote:
On 9/01/2010 10:53 PM, Amy Smith wrote:
snip /
How to use mount for differnt region.
I do not understand this question. Can you explain what you mean a bit
more?
Probably wants tablespaces?
\\||/
Rod
--
--
Sent via pgsql-general mailing list
semi-ambivalent wrote:
On Oct 21, 8:54 pm, da...@fetter.org (David Fetter) wrote:
On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote:
If I have a table with fields A, B, C and D how could I do something
such that if I insert values in fields A, B and C field D would be
auto-filled
John wrote:
Hi,
Is it better to create multi databases or create multi schemas?
John, I just gave a talk on multi-tenant Pg clusters at PgConf West
2009 that may help you but ran into vehicle problems and just got home
this evening. As quick as I can I'll get the bits-and-pieces pulled
Jasen Betts wrote:
On 2009-10-09, Peter Eisentraut pete...@gmx.net wrote:
On Fri, 2009-10-09 at 11:46 -0700, Christophe Pettus wrote:
Domains are basically type aliases with an optional CHECK clause, so
you could do something like:
CREATE DOMAN sales_tax_rate AS DECIMAL(5,5) CHECK
OOPS I got caught by the reply verses reply-all and only sent this to
Scott. Plus I see it has already been addressed in a later message.
raa
Scott Marlowe wrote:
So, can you just set search_path to point to all the schemas at once
then? Or does that not meet your needs?
The only issue I
Sam Mason wrote:
On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote:
Thanks for response, bit if I point it to all the schema, I am just
wondering how data insertion will work, I have multiple ables with
same name in these applications.
Do you know that you can schema qualify
Philip Rhoades wrote:
People,
It would be nice to be able to use PostgreSQL as the storage for Firefox
Bookmarks - anyone know if this would be possible? how it could be done?
Not sure about doing it with PostgreSQL but there is the Firefox Weave
Service which might do what I think you're
sw...@opspl.com wrote:
Hi,
I believe that command is specific to the debian/ubuntu distributions.
in generic postgres, you'd simply stop the server, then delete the
contents of the $PGDATA directory
I am using CentOS 5 and postgrest 8.1.11 . Could not find the PGDATA
directory. :(
On
Scott Mead wrote:
On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly li...@alteeve.com
mailto:li...@alteeve.com wrote:
Hi all,
I work on a development and production server, and I am always
double-checking myself to make sure I am doing something on the
right server.
Is
Brandon Metcalf wrote:
g == gryz...@gmail.com writes:
g you should use it, whenever you need db to keep its own key internally.
g Advantage of sequence is also the fact, that you can have the sequence
g value used on different columns/tables .
g My rule of thumb is , in that case: as long
A quick request for a pointer to look or an answer.
Background:
I was asked to test the results of a pg_dump of a database.
While and after doing a import (\i file_dump) I notice one table had
two attributes with a type of unknown. I'm not sure of the Pg version
it cam from but I was
Tom Lane wrote:
Roderick A. Anderson raand...@cyber-office.net writes:
While and after doing a import (\i file_dump) I notice one table had
two attributes with a type of unknown.
Is it a table, or a view? This is hardly unheard-of for views,
consider
Table. The columns are to hold
Scott Marlowe wrote:
On Sat, Apr 18, 2009 at 8:27 AM, Rainer Bauer use...@munnin.com wrote:
Hello Scott,
Saturday, April 18, 2009, 4:21:29 PM, you wrote:
SM On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer use...@munnin.com wrote:
Hello,
I signed up a couple of months ago but never received
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database
John R Pierce wrote:
Roderick A. Anderson wrote:
snip /
make sure pg_hba.conf on the old machine allows you to connect from the
new machine's IP address as the user postgres (this may require setting
a database password for the postgres user on the old machine if the
'host' authentication
Joshua D. Drake wrote:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
I can't avoid it any longer and have to move an old RT2 installation to
a new machine. (I'll upgrade to RT3 on that machine.)
The plan calls for a pg_dump using my workstation using CREATE the
database
Tom Lane wrote:
Joshua D. Drake j...@commandprompt.com writes:
On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote:
The plan calls for a pg_dump using my workstation using CREATE the
database and INSERTS (-C -D) . Then use psql to run the script created
above to build the database
I'm trying to determine the permissions PUBLIC has on several
tables/views. Or would this be the default permissions for a table/view?
pg_user, pg_roles, pg_group, pg_authid, pg_auth_members, pg_database,
pg_tablespace, and pg_settings.
\dp pg_user
returns (0 rows).
I am logged in to
In my continuing quest for multi-tenant ways I'm trying to come up with
a method to name roles, users, and groups that will not clash across the
cluster. The plans are to have one database per tenant and place
applications in different schema in those databases. This is working
fine so far
Roderick A. Anderson wrote:
In my continuing quest for multi-tenant ways I'm trying to come up with
a method to name roles, users, and groups that will not clash across the
cluster.
snip /
While testing and researching I discovered prior work. I was using
different terminology.
http
Scott Marlowe wrote:
On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson raand...@acm.org wrote:
I've done some searching using Google and found a few papers and articles on
multi-tenant databases. I still have to read through many of them but there
didn't appear to be much reference
I've done some searching using Google and found a few papers and
articles on multi-tenant databases. I still have to read through many
of them but there didn't appear to be much reference to using PostgreSQL
in the ones I found.
Can anyone suggest sources of information on this topic --
Robert Fitzpatrick wrote:
I try to use dblink_connect while logged into the database as the
superuser and it returns OK, but if I disconnect and use the same
command as follows, it give and error, password is required. Even if I
try to use the superuser login in the connect string below while
Tom Lane wrote:
Craig Ayliffe [EMAIL PROTECTED] writes:
I have several Postgres DB's not showing correct daylight savings time.
From maillist etc I believe these are patched up to the right levels to have
the correct time zones - but they don't seem to be working still.
No, you're behind
Tom Lane wrote:
Roderick A. Anderson [EMAIL PROTECTED] writes:
Tom Lane wrote:
No, you're behind the times: 8.2.4 and 8.1.9 are too old to know
about this year's changes in southeast Australia DST laws. Which
I imagine is what's biting you.
Doesn't Pg use tzdata (at least that's what it's
Scott Marlowe wrote:
On Thu, Oct 16, 2008 at 8:52 AM, Roderick A. Anderson [EMAIL PROTECTED] wrote:
Tom Lane wrote:
CentOS 5 -- three, four, or maybe more, updates this year so far. :-)
Is there a way to determine from a binary install (Devrim GÜNDÜZ's rpms) if
it uses the system timezone
Sorry to all but my original reply went to Dave instead of the list.
Gauthier, Dave wrote:
Wait, I also appear to have plperlu (createlang plperlu seems to have
worked successfully).
Now if it will do what you need. :-)
Rod
--
-Original Message-
From: Roderick A. Anderson
Kevin Hunter wrote:
At 7:13am -0400 on Thu, 11 Sep 2008, Harald Fuchs wrote:
Nice trick, but when I try the following variant:
psql -v TEST=16 -c 'select :TEST as input'
I get [a syntax error]
This seems to be contrary to the psql manual page:
Nope. Take a look at the -c option.
Mark wrote:
On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold
Andrew Sullivan wrote:
On Thu, Aug 14, 2008 at 04:20:14PM -0700, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
What about a datatype? I have reason to believe that a company I used
to work for implemented such a thing. There was some talk
David Goodenough wrote:
On Friday 15 August 2008, Roderick A. Anderson wrote:
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can
Steve Atkins wrote:
On Aug 15, 2008, at 12:16 PM, Andrew Sullivan wrote:
On Fri, Aug 15, 2008 at 07:44:36AM -0700, Roderick A. Anderson wrote:
Thanks again. This is a pretty specialized application (at this
time) so
the RRTYPEs used are limited. I am trying to make the model and Pg
Anyone aware of an ER model for holding name server records?
Working on the zone file data and I am getting close but keep running
into the differences between MX records (with a priority) and the others
that can hold either a domain/sub-domain/host name or an IP address
depending on whether
Kevin Kempter wrote:
On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote:
I was wondering if anyone knows of any good ER Diagram tools for
Postgres that run on Linux.
If you're not against paying there is dbwrench http://www.dbwrench.com/.
Java so it could be a bit of a problem because
Olexandr Melnyk wrote:
Joe Celko's SQL Programming Style is a good not vendor-specific book.
And maybe a bit too Developer/User-ish but very good his SQL for Smarties.
Rod
--
As for PostgreSQL-specific books, I can only speak for one I read
before: Bruce Momjian's PostgreSQL: Introduction
Hopefully the original post went astray and this isn't a duplicate. I
don't see it in the archive so I'll assume I have a bogus SMTP setup at
work for my home account.
I've tried the Pg docs, DBI book, and Google searches but haven't found
anything useful on this topic.
I realize this is
Greg Sabino Mullane wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Will a $sth-execute()
of a SELECT ... FOR UPDATE statement allow me to update the selected
records using
$uth-execute( ... )
if $sth and $uth are both created/prepared from the same database handle
$dbh?
You are
Alan Hodgson wrote:
On Wednesday 18 July 2007 14:29, Roderick A. Anderson [EMAIL PROTECTED]
wrote:
In the mean time if the script gets triggered again and the first
instance isn't finished the second needs to not be able to select those
records already being handled.
select for update won't
Richard Huxton folgendes:
Roderick A. Anderson wrote:
Works great ... up to a point. I now need to change the users and
owners associated with all the tables without changing their permissions.
Is there a way or hack to do mass changes like these.
Write a small plpgsql function to take
Back in September Bobby Gontarski asked about copy db1 to db2.
Jim Nasby came back with the suggestion of using db1 as the template for
creating db2.
Works great ... up to a point. I now need to change the users and
owners associated with all the tables without changing their permissions.
Tom Lane wrote:
Roderick A. Anderson [EMAIL PROTECTED] writes:
I've add a new user and as I go though granting various accesses to the
different tables I realized many of those tables have primary keys that
are generated by a sequence.
Do I need to grant access on the sequences and what
I'm working on an application ( using Catalyst ) and realized I was
using a user with too many privileges to access the database.
I've add a new user and as I go though granting various accesses to the
different tables I realized many of those tables have primary keys that
are generated by a
Rich Shepard wrote:
I'm trying to help the XRMS developers add postgres support ('cause
that's
what I use). They've done well so far with help from other postgres users,
but now I've been asked to help getting the indices correct.
Hi Rich. Seems once again we're meeting in the same places.
Just rejoined after a year of so of being away and have a question. The
Search from the PostgreSQL.org mail-archives site isn't working ( or
maybe not working like I think it should ) I get a 503 Server error.
The quesion just came up, as we start the process of moving from MySQL
to
I am trying to come up with a method to have a default value for a
column based on a function and other columns. I'm hoping ( well not too
much ) that what I figure out here will apply to MS SQL Server as I am
stuck using it unless I can prove there ain't no way it's going to
happen. ( Now
On Tue, 6 Jan 2004, Adam Ruth wrote:
One thing I'd suggest would be to modify the application to issue a
set search_path = yourschema; at the beginning, then the rest of the
application wouldn't need to change. That's what I did when I did
something similar.
Neat idea. I was thinking
On Tue, 6 Jan 2004, Oliver Elphick wrote:
You can use ALTER DATABASE to set that up permanently, without touching
the application.
I'd thought of this but since there will be several applications installed
and some, I am sure, will have same-named tables this could back-fire.
Rod
--
On Wed, 7 Jan 2004, Martijn van Oosterhout wrote:
Are you actually going to be doing joins between these applications?
If not, why not setup multiple databases, then you can be sure they
won't conflict.
Well in at least one situation I can think of there will be joins. And
with a minimum of
On Sun, 4 Jan 2004, A E wrote:
Hi,
Was wondering if there are ways to completely script a new postgresql
installation. I need to be able to create the db, users, and db
elements from one command so that I can included it in a setup
routine.
How about pgbash. Is it still being supported?
On Tue, 23 Dec 2003 [EMAIL PROTECTED] wrote:
I just installed RH9 on a new machine and installed postgres in the
installation process. I got the following error when trying to
start the postmaster so... I tried removing the postgres software
then reinstalling. rpm first said the software
I'm dealing with a project that requires me to query a MS SQL Server. Not
a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL
standard? MS SQL Server uses a TOP modifier.
select top 1 * from xxx;
Whereas all the SQL RDBMS' I've used before used
select *
On Mon, 15 Dec 2003, Arjen van der Meijden wrote:
Nonstandard Clauses
The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL
standard.
Humm. Is there a SQL standard to return a subset of the selected tuples?
This being contrary to relational theory I believe. :-)
TOP x
On Tue, 2 Dec 2003, Lamar Owen wrote:
Because Pg is no longer distributed as a part of the main tarball, but a
contrib is being distributed that requires it. This is an issue with the
main tarball, not with the RPM packaging, IMO. Someone needs to step up to
the plate and build a Pg RPM
Any pointers as to why (really) I'm getting this error when I try to
install Pg 7.4 from a SRPM build?
perl(Pg) is needed by postgresql-contrib-7.4-0.2PGDG
I only disabled tcl, tkpkg, pltcl, and python in the SPEC file. I could
not install the contrib stuff but I really want the plperl
Hopefully not fuel to the RPM discussion but I've downloaded the PGDG SRPM
this AM made some changes to what packages/portions would build and am now
getting the following error.
gcc: cannot specify -o with -c or -S and multiple compilations
Somewhere near line 719 in the spec file.
The
I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but
there are several other dependencies I have to resolve first) and I need
to update one database's tables so they can be merged into the other
database's table. I know I can drop the constraints and update the tables
(primary
On Mon, 11 Aug 2003, Stephan Szabo wrote:
Yes. Either DEFERRABLE or INITIALLY DEFERRED must be given in order for
set constraints to be meaningful. This might be another good place to
consider a little clarification (or maybe a doc note in the interactive
docs)
Phew. I thought I was going
On Tue, 12 Aug 2003, Dennis Gearon wrote:
Yuup, always name constraints so it's easier to remove them. And if
you name them meaningfully, then others might understand why they
exist! (or later after a coffeeless morning)
This application has grown as a fungus: in the dark and nourished on
On Thu, 26 Jun 2003, Lamar Owen wrote:
{/usr/src/redhat/RPMS/i386}# rpm -Uvh --test *.rpm
error: Failed dependencies:
perl(Pg) is needed by postgresql-contrib-7.3.3-1PGDG
Argh. That's supposed to be fixed; apparently I did something wrong. Install
it with --nodeps for now, while
On 26 Jun 2003, Manuel Sugawara wrote:
Lamar Owen [EMAIL PROTECTED] writes:
If you want to help troubleshoot, look at the
filter-requires-perl-Pg.sh script (Source16) and see where it needs
to be invoked
But ... contrib *depends* on perl (see contrib/rserv for
instance). May be
On Mon, 10 Sep 2001, Tille, Andreas wrote:
Hello,
Now I started some performance comparisons and did the following statement:
The MS-SQL server represents the result immediately - you just not notice
any delay. If I do it on the PostgreSQL server it takes 30s on comparable
hardware
I was going to suggest this last week amd now it looks like it might be
more important. (There was a namserver problem with this account soI
never got Bruce's original post - just the replys/follow-ups.)
Well since I got layed off last December it has been interesting trying
to find employment
On Thu, 16 Aug 2001, Martijn van Oosterhout wrote:
You can tell the order anyway. The order doesn't change, it's only that
there may be numbers missing,
Please note the message from Michael Ansley (UK). If two of more
connections get a cache from a sequence and the inserts are 'sporatic'
On Mon, 6 Aug 2001, Allan Engelhardt wrote:
Peter Eisentraut wrote:
This won't work. You need to be able to write to the medium for a number
of reasons.
Is the reason that PostgreSQL must have log files etc. in the same
directory as the data files (it does not appear to support, for
On Fri, 4 May 2001, Robert wrote:
I write the same application for the same reasons - we're three
partners and we all want to be able to create invoices and also see what
others create.
Have you looked at SQL-Ledger? THough I disagree with some of the
table designs it is a pretty good
On Mon, 19 Mar 2001, will trillich wrote:
On Mon, Mar 19, 2001 at 09:50:20PM -0500, Bruce Momjian wrote:
Psql backslash commands use it to describe tables, types, functions,
etc.
i realize that, coach. i'm wondering if any devious minds
out there are using it for something clever and
On Tue, 30 Jan 2001, Jeff wrote:
I have a design question. Lets say we want to keep track of users and
their respective snail mail addresses. Each user can have up to 4
different mailing address. Is it better to have all this information in
one table.
Only if you have mostly 4 address
Mine _arrived_ last Thurday from Barnes and Noble. No notice about
shipping though!
Rod
--
On Sun, 17 Dec 2000, Brett W. McCoy wrote:
[snip]
Greetings from Amazon.com.
We thought you'd like to know that we shipped your items today,
and that this completes your order.
...
The
On Tue, 12 Dec 2000 [EMAIL PROTECTED] wrote:
Hello, can you PLEASE send me some information on what this is all about.
I'm lost here. I'm brand new to the whole SQL language and I need all the
help I can get.
Thanks,
Sounds like trolling for e-mail addresses.
Sorry but I'm not an AOL
On Mon, 4 Dec 2000, Nancy Ellman wrote:
However, while I have been able to see the results of the first
example with
\dd mytable
Try \d+ mytable
Rod
, and then update /etc/fstab for the system.
Seems to work but it is a kludgy method to do it. What I'd like to do
is mount the partition before doing a createdb.
Will this work with 7.1? (I'm writing up some instructions that I'd like
to not have to change later.)
TIA,
Rod
--
Roderick A. Anderson
On Mon, 16 Oct 2000, Alfred Perlstein wrote:
huh? How are you copying to an unmounted partition?
Sorry I left that step out of the description. I usually mount it to some
dumy point long enough to copy the files then unmount it and mount it to
the database directory.
Rod
--
Roderick
about two weeks ago.
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814
On Tue, 3 Oct 2000, Tom Lane wrote:
"Roderick A. Anderson" [EMAIL PROTECTED] writes:
select tbl_key, equipname from equipment
UNION
select 'All', 'All Equipment' from ???
Postgres has a cleaner answer than a fake table; just omit the
FROM clause:
As I discover
need to add them as part of the adduser/useradd
process and/or run a script against the passwd file to create them.
rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX
researching but was hoping someone might have their own quick-and-dirty
list of directions. Heck I'd go for a URL even ;-)
TIA,
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
' ]
[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
[ VALID UNTIL 'abstime' ]
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299
) and compiled
with perl2exe to make the installation impact (not a full perl
installation) on the Windows systems a little lighter.
Any and all pointers apprciated,
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149
ster and more
memory conservative. (Been reading too many perl books lately so I can't
say where I saw this.)
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite
On Wed, 7 Jul 1999, Kaare Rasmussen wrote:
I'd like to ask if it's on the web?
The magazine (www.samag.com) but not the article. Maybe later in the
year. I can't remember the policy right now.
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc
on the list aware of someone building these functions so they
are usable in triggers? (Of course I'm now thinking I've seen mention of
soundex being a part of PostgreSQL. Go figure!)
Any pointers or suggestions are greatly appreciated.
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED
.
TIA,
Rod
--
Roderick A. Anderson
[EMAIL PROTECTED] Altoplanos Information Systems, Inc.
Voice: 208.765.6149212 S. 11th Street, Suite 5
FAX: 208.664.5299 Coeur d'Alene, ID 83814
84 matches
Mail list logo