? Could a smaller db like sqlite be a better option?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
te world street map like google maps comes
in at?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ou to build an "access style" front end that
isn't fixed to one db structure.
dim rs as recordset
rs = db.sqlquery("select...")
for x = 1 to rs.fieldcount
if vartype(rs.idxfield(x).value) = kTypeDate then
...
...
next
you could also use rs.idxfield(x).stringvalue and p
ow
instead of a one off from the constant in the select.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
eving it is all just mythology.
Of course the true believers will argue endlessly about the wonders of
what can be done and how important it is, but they tend to have a low
conversion rate among the listeners.
;-)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.B
of info.
- made sure my OS X Server Firewall has a hole for the port to be used.
If you have missed this then you need to open port 5432 on your firewall.
What am I missing? Any help would be greatly appreciated...
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http:/
It was a few versions ago so may be changed by now, but I reckon it
was the temp_store setting - which is described as temp tables and
indexes but is (or was) also used for large query and sorting needs.
Setting this to memory did make a difference for some queries.
--
Shane Ambler
pgSQL (at
the software is designed to do.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
sem
kern.ipc.semaem: 16384
kern.ipc.semvmx: 32767
kern.ipc.semusz: 92
kern.ipc.semume: 10
kern.ipc.semopm: 100
kern.ipc.semmsl: 60
kern.ipc.semmnu: 30
kern.ipc.semmns: 60
kern.ipc.semmni: 10
kern.ipc.semmap: 256
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent vi
eneral tab of the project inspector. [SDKROOT]
NOTE - This is an Apple GCC extension - I don't think it has made it
into the general GCC release.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-genera
as opposed to on-board controllers)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you're really squeezed for space and money then you can use RAID-5 but
it has some seriously negative performance implications for parallel
load handling and write speed.
You may also be interested in looking at BioPostgres
http://phenomics.cs.ucla.edu/
--
Shane Ambler
pgSQL (at) Sheek
d have created it.
As the postgres user existed the EDB installer would have left it as is.
If you want a GUI to alter the home location of the existing user
account run NetInfo Manager which is in /Applications/Utilities
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Bi
Alan Hodgson wrote:
On Thursday 28 August 2008, Shane Ambler <[EMAIL PROTECTED]> wrote:
If you have a filesystem backup from 6 hours ago, then the WAL
files as they are now can be used to update the backup to match the
db as it is now. This makes the filesystem backup have two poi
es are useful
even if not doing a physical backup of the actual database files.
John
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
and all of it's associated contents in your z drive folder - outside of
the cluster's data folder where the logs, transaction logs and system
wide data is located.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgs
join are correct?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Shane Ambler wrote:
[EMAIL PROTECTED] wrote:
Is the otool program on your system anywhere? Afaik, it should be on
any Mac, but maybe it's part of xcode (i hope not- can anyone
confirm?)
I have a few installs here.
now that I think about it - it may be a dev tools only thing.
oto
ed on also includes otool
at /usr/bin
A minimal 10.3 install has otool at /usr/bin
A clean 10.5 install does not have otool
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
(DEFAULT, 'y','z') before, I have always gone with
INSERT INTO table (fld_x, fld_y,fld_z) VALUES (NULL, 'y','z')
is DEFAULT a better option than using NULL? or is it just a preference
to spell out the implied default entry?
I've only used DEFA
27;, 'z');
Another way is INSERT INTO table VALUES (NULL,'y','z')
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
n some talk about getting postgres to build as a universal
binary. The current makefiles don't support the option but a couple of
people have come up with work arounds. I do believe that there are plans
to add this to future releases.
An informative post would be -
http://archives.postgresq
get some guesses about whether 2 or 4 GB will
suit your situation.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql
areas are likely to have changes can help you design now to
make it easier later.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
to run until you drop a column they depend on.
To change the use of an existing column can have a similar affect. A
little thought before you make changes to consider how the change will
affect existing apps can prevent these issues.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sh
e are things committed? After entry or at user logoff?
Is there some user data updated on logout that gets an error and rolls back?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
b only holds non-default options.
I would think that one table is sufficient for the scenario you describe.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
h
need to weigh up
these changes to decide whether app v1.x will continue to be usable or
must be upgraded for further use. Of course you can leave an old column
there for old apps and have new apps ignore it eg. remove it from SELECT
statements in the new app.
--
Shane Ambler
pgSQL (at) S
. DROP TABLE mytable_with_money
5. psql < mytable_backup.sql
While the data is in a text file regex tasks to remove the money
formatting become a lot simpler.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
basically the same with different contributors.
I am sure there was another but I can't seem to recall what it was.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
orm slowly.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ble to the new server
history table.
As the table on the new server grows exponentially (already nearing 1M
records) I need to do this asap unless I want the entire thing to take
forever... (sweat)
Could someone please lend me a hand here?
Already thankful for any insight,
--
Shane Ambl
view with a new query that generates the
identical set of columns (i.e., same column names and data types).
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your sub
x27;s will cause you some headaches (think endless loops).
You may want to have one db with the table and use functions to access
the data from the other db.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgr
Semi Noob wrote:
My CPU is 2CPU: Intel(R) Xeon(TM) CPU 3.20GHz. Disk: disk system is RAID-5;
Early versions of postgresql had issues with P4 HT CPU's but I believe
they have been resolved.
I am quite certain that it only related to the early P4's not the Xeon.
--
Shane Am
le's installer setup.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ry, by
the
way, this is not the biggest table that i have others have more than
50300 registers, so if I try to do a cross select between tables it
could be worse.
You may hear from people on this list that have db's storing many
TeraBytes of data.
--
Shane Ambler
pgSQL (at) Sheeky
s but as far as I know you have the same options.
From a dos prompt (I would cd to c:\program files\postgresql\8.2\bin)
enter postgres --single dbwithproblems
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@pos
connected to the same db you are connected to when you run
psql?
I would probably add the CREATE LANGUAGE command to the start of the
perl script.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org
e you install how to get started using it? How to do it depends
on the operating system you are using. Once you have it installed
you may want to join the Postgis newsgroup for further help
http://postgis.refractions.net/mailman/listinfo/postgis-users
Hope that helps, Regina
--
Shane Ambler
.log?
Is the shp file known to import ok on other installations?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
more
restrictive license and each must be checked individually.
See the following for full license which is also included in the source
files -
http://www.postgresql.org/about/licence
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing
n they request it? Or are you set on
automating the syncing?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
you may need to find as root from
the terminal.
I believe if it's getting far enough to actually try running PostgreSQL
the logs would be being put somewhere like /opt/local/var/log/postgresql82
(or at least the 83 port seems to put it in a postgresql83 from there)
--
Shane Ambler
it. A couple of them might help you find someone with a
copy of it.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
than cross db data sharing.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Greg Smith wrote:
And if anybody suggests putting a "_" in something I have to type all
the time, I will stick my fingers in my ears and start yelling until
they stop. Bad enough I have to type pg_ctl a few times every day now.
+10 on hating "_"
--
Shane Ambler
pg
rrent named progs in place for a few versions though. Or
have them as a config option.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresq
using the restore command in pgAdmin (Tools menu).
If it doesn't work, backup from pgadmin as a plain file and compare what
it puts out to what you have done.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@
untime)
On *nix you would do something like -
echo "\copy mytable from mylocaldata.csv" | psql
I'm sure you could do a vb script to do that for you if you wanted to
stay in Access.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql
If you start psql then you can use the psql command \i myscript.sql to
run the script.
You may need to add full pathnames in these examples.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
to
distribute your connection requests between these replicated servers.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
your where clause for the argument types.
Now I'd go the other way and SELECT count(*) FROM
If it ain't there you get 0 returned - no errors.
In your function you can test >0 and return true else false or you can
return the count and test numerically against the return.
-
ogether as well as how your
client will access it, than on the limits of number of tables that can
be created in one db.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to yo
Thanks,
Pavan
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
what has been done on it)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
) idle
which is the info you are after - pgsql is the dbusername, postgres is
the db they are connected to then the ip address and port they are
connecting from. The idle at the end will be replaced with the query
they are running.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky
he current erroneous recording.
I am thinking that a cron job that will email/page/sms you when it hits
50% disk usage would be a better solution that would simply give you a
heads up to find and fix the fault causing the excess usage.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get She
es code to start Illustra.
After Berkeley dropped the Postgres project it was picked it up by a few
developers and grew into PostgreSQL as you know it today.
http://www.postgresql.org/docs/8.3/interactive/history.html
http://en.wikipedia.org/wiki/Michael_Stonebraker
--
Shane Ambler
pgSQL (
it refers to.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
y just crawl in the last 2)
Maybe sub-times can be a second table.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
/interactive/catalogs.html
particularly pg_class and pg_attribute
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an
o get some more info in the log
log_line_prefix - %t will show the timestamp of the log entry
log_statement - can record the queries to the log so you can see just
what is being run as you go through the log.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheek
iration.
http://code.google.com/p/sepgsql/
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
--
PostgreSQL 8.2.5 on powerpc-apple-darwin8.10.0, compiled by GCC
powerpc-apple-darwin8-gcc-4.0.1 (GCC) 4.0.1 (Apple Computer, Inc. build
5367)
(1 row)
Mac OSX 10.4.11
G4 dual 1.25G
2GB RAM
--
Shane Ambler
pgSQL (at) Sheeky (d
://projects.commandprompt.com/public/pgsql/repo beta1
Sincerely,
Joshua D. Drake
--
Mark Walker
Was it beta2 that changed the structure or beta3?
Anyway worst case I still have a beta1 source tarball here if you need it.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
he tablespace. Filesystem backups/xfers are
possible, but that requires copying the entire cluster directory. If
all you want is a specific tablespace, then pg_dump is your friend.
Lesson to take from this: NEVER delete the original without validating
the backup.
Erik Jones
--
Shane
gs toward seqscan.
If you wanted to test this out try adding 1000 rows to phpbb_banlist,
analyse then explain the query again and see if it goes to the index then.
If you wanted to experiment enough you should be able to find a "sweet
spot" of x rows where it will change between inde
g/docs/8.2/interactive/maintenance.html
can explain these tasks in more detail.
If this is insufficient then you can also look at your config file.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
ttp://www.entropy.ch/software/macosx/php/
has been a good source of pre-built php for osx which also provides a
larger feature set compiled into php.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
ttp://www.entropy.ch/software/macosx/php/
has been a good source of pre-built php for osx which also provides a
larger feature set compiled into php.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
base system that's a joy
to work with.
/Kevin (Although not the same Kevin as above)
/me takes note of all the Kevins that are handing out hugs...
:)
Yup .. I'll dish out a dose o' them too..
;-)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get
xid data type cannot be
loaded in database 'dbname=testdb1 host=172.31.0.67 user=josh'
:21: ERROR: no admin conninfo for node 134701624
The same works fine between postgresql versions 8.1.10 and 8.2.5 .
Why do I get this error when replicating between versions 7.4 and8.1.
Does slony1
the future. This should be:
You must be a Jedi Master as well because I can't see the source.
(at least not the tarballs)
;-)
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/r
s the last release at May 2007. The project home is now at
http://www.pgcluster.org (but they seem to use pgfoundry to store the
release tarballs)
Also Cybertec appears to have branched off from pgcluster
http://www.postgresql.at/english/pr_cybercluster_e.html
--
Shane Ambler
[EMAIL PROT
n PostgreSQL? It would have to be
something like pgPool (middleware), because: How would the query know on
which server to put it's data? And i guess i would need some Kerberos-like
implementation for my authentication and authorization...
cheers,
WBL
On Nov 29, 2007 1:23 PM, Shane Ambler &l
achieve.
Some of the projects that add these features are mentioned.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe
te a Name Loopup problem?
If there is no entry (or an incorrect one) in /etc/hosts for localhost -
then yes - try to connect to 127.0.0.1 and see if that makes a difference.
Also if it is set to do namelookup before referring to /etc/hosts it can
have similar probs.
--
Shane Ambler
[EMAIL
a stored procedure that takes an id argument
(and can usefully invoke it on any stock_id in the
database), but the problem remains as to how to
construct a record set by applying the procedure to
each id in a set of ids returned, e.g., by SELECT
stock_id FROM stocks;
Ted
--
Shane Ambler
[EMAIL PRO
Shane Ambler wrote:
> I INSERTed 500 stocks entries and 10,000 stockprices entries for each
stock (that's 5,000,000 price rows), then from
EXPLAIN ANALYSE SELECT * FROM stock_price_history WHERE stock_id = 20
I got - Total runtime: 981.618 ms
EXPLAIN ANALYSE SELECT * FROM stock_price
can change the settings if
you wish.
This is most likely the reason for your "lack of compression" - the data
in the toast tables is most likely already compressed data so will be
close to a 1-1 export size.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://
ery to be -
SELECT * FROM stock_price_history WHERE stock_id IN (SELECT stock_id
FROM sometable WHERE )
Which gives you the range of stock_id's from a table that you asked about.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
ight
direction...
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 6: explain analyze is your friend
ember table then you will need to
repeat the calculations instead of referring to the alias. And if this
is the case how does the insert fit with the issue of the select?
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)--
and have a look
through the stored procs and functions that it uses.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
picky. You could actually not use the created_at in
the sorting as the id will give the same effect by itself.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
do the dump/restore even if it
is sent straight from one to another.
For more help specify what hardware, system and postgres version you
have on each machine and what you wish to achieve in transferring.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---
connect
to mydb1 and can only perform selects on mydb1.
Within postgresql these user accounts are referred to as roles - see the
manual on CREATE ROLE for more info.
http://www.postgresql.org/docs/8.2/interactive/sql-createrole.html
--
Shane Ambler
[EMAIL PROTECTED]
s the only one with
read access to the data files then other users have trouble getting a
copy of them.
If you run ps aux (or activity monitor) you will see a few different
user names listed for different services.
Shane Ambler <[EMAIL PROTECTED]>
10/18/2007 01:27 PM
To
[EMAIL P
rary/StartupItems/PostgreSQL/PostgreSQL start
Also which version are you installing and did you get a binary package
somewhere or are you building from source?
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
x27;t need the data all together think forward to what may happen in
the future, and how much work it will be if you do change your mind.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting
plain most of these
terms.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that
st to
implement that provides enough security for your needs.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-no
ly? Or do they have to approve the address as being correct at
which stage it is immutable?
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 6: explain analyze is your friend
d record?
Any idea is appreciated.
Thanks in advance.
Luca
_
Watch all 9 Live Earth concerts live on MSN. http://liveearth.uk.msn.com
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
r | Encoding
---+-+--
postgres | pgadmin | UTF8
template0 | pgadmin | UTF8
template1 | pgadmin | UTF8
wiki | pgadmin | UTF8
(4 rows)
Then DROP DATABASE dbname; to delete it data and all.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end
prefix dirs) at
the same time then you probably want to make sure that your shell $PATH
setting includes the path to the newer version of psql and then specify
the full path to the older version of psql when you want to use the
older version. Or just use the full path every time you run psq
ccessed only by selected roles
then you revoke public access when you create it and allow access to the
one or more roles you want to allow access.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 6: explain analyze is your friend
nance of this
will outweigh any benefit.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
pitalize SQL
keywords and leave everything as lower case. (Makes for easier reading
later.)
Kevin
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
1 - 100 of 185 matches
Mail list logo
