server and create the users/groups they will use then
create the database for them with the structure you want in it. You only
need to transfer the one database structure from your development server
not your entire cluster.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheek
there
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ctive/ddl-partitioning.html
--
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
LE users if they excided some
time or some program which will purge memory from non active posgres.exe
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignor
them directly, console.log is in /Library/Logs/Console and
system.log is in /var/log
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 6: explain analyze is your friend
at you will see on the
terminal if you run pg_ctl directly.
--
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 c
e familiar with the terminal then ps aux | grep postgres will
list any processes running. If there are any stop postgresql and if the
.pid file remains delete it then start postgresql.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(e
run in the background.
(that would include a space and then the & after the last character in
the command)
If you have a startupitems folder to start postgresql on startup then
you can also use that to start/stop postgresql manually with -
sudo /Library/StartupItems/PostgreSQL/PostgreSQL
client is updating this data?
I would think that the client could keep track of changes as they are
typed and save this info with the updated data thus removing the time to
compare the before and after data at the DB end.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://
by
character) and records the differences.
Shane Ambler pí¹e v Èt 23. 08. 2007 v 22:21 +0930:
Karel Bøinda wrote:
Hi,
I have a question about PgSQL. I am working at some project and I
want
to have few tables with special properties:
There would be many rows and these would be changed every
n the
windows machine that has a compatible version of php enabled. Then just
place the files within the web server directories as you would any other
web pages and follow the config steps to get it to connect to the
postgres server.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheek
e that may help you for now is
http://www.entropy.ch/blog/Software/2006/02/04/PostgreSQL-Universal-Binary-Build-Tips.html
and
http://www.entropy.ch/phpbb2/viewtopic.php?p=9579#9579
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of
pplies fat binary libs with osx.
From there to postgresql is a network connection (or local socket) so
each program is just sending data to the other - they don't need to be
the same architecture any more than you need a 64 bit sparc browser to
connect to a 64 bit sparc web server.
--
Sha
with 7.4.19 (using a copy of your
data files of course)
As well as planning an upgrade to 8.1 or 8.2
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner
in
Postgresql?
Also if I create a new user with su postgres -c "createuser -A -d
globus" .Will it set any default password while creating the user ??
No password is stored unless you specify it.
As much as these are ways around your inconveniences, you should also
consider t
ss file.
If you are at a point where you want to automate setting up a large
number of new systems and you don't know enough about *nix systems to
create these scripts yourself then you should take a few steps back and
learn more about *nix sysadmin before you move on.
--
Shane Ambler
ernal network?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
h is
what the firewall would need.
I do know that some systems will not allow a program to change this
setting so it must be done in the system config.
Thanks
Paramjeet Kaur
-Original Message-----
From: Shane Ambler [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2008 12:48 AM
asename2 in this case)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
the other?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
s the other entries that can be refined to that)
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
appear to come from?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
and new server you can pipe the dump output to psql
sending it straight to the new server.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
orage but most
of the details will be found in the source.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
from source?
If you built from source before you need to assign the same ./configure
options as you did previously.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your sub
our table defs in 8.3 and see if the fk constraints are in place.
You would have two choices - clean up the data in 7.4 before the export
or clean up after the import and before the fk constraints are added.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent
diferent directory and drive than Postgre's.
Did you specify the tablespace when creating the db? or create the
tablespace after the db?
Is the drive NTFS or FAT32? (system and the tablespace drive)
What version of windows?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @
Is postgres already running? are you running the postgresql restart as root?
In your data dir you should find serverlog that should give more info -
also try system or console logs
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing l
march
march has 31 days so 1st of march plus 1 month puts you at 1st of april.
Try a leap year -
select ('2008-02-01 12:00:00'::timestamp + '1 month'::interval) -
'2008-02-01 12:00:00'::timestamp;
?column?
--
29 days
(1 row)
--
Shane Ambler
pgSQL
are trying to enter - "t8.episode_name -1::bigint" into the column
hence - "character varying - bigint" does not work
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to
s you also get issues like
data alignment and unused space on a page that doesn't fit a row...
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
dir it is located in and the one running the software that will use
it) is the only one that can access the data in the file. Normal
permissions setup on windows will match this.
It's use is a convenience and I think for the most part not highly
recommended.
--
Shane Ambler
pgSQL (at) S
ou edit it on windows with cr/nl characters and copy it across to linux?
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
. Note that "password" sends passwords
# in clear text; "md5" is preferred since it sends encrypted passwords.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
systems, it has no such advantages in PostgreSQL.
In most situations text or character varying should be used instead.
http://www.postgresql.org/docs/8.3/static/datatype-character.html
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list
sent. You could then filter these sql statements out of the
logs leaving you with hand crafted sql.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.post
ql.org/docs/8.3/interactive/sql-createfunction.html
Another option would be to have them use a different user name when
using psql. Probably not an option unless the app runs with it's own
username.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via
m the synchronising.
You will either want a list of changed records per client or modified
timestamps to determine what has changed since the last synchronise, as
well as define actions upon conflicts.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin ma
will not read from the same data files.
You will need to dump and restore to transfer the data across.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
Get Sheeky @ http://Sheeky.Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http
Migrations currently supports
Derby
Oracle
PostgreSQL
Patches for other databases are welcome.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
look into other options for log file rotation.
--
Shane Ambler
pgSQL (at) Sheeky (dot) Biz
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
)
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
y you want to do it. You will need to do a find and replace on the
INSERT's to change the table name though.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 1: if posting/reading thr
pgsql folder from there then goto
/Library/StartupItems and delete the PostgreSQL folder.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ll need to give
some more information - are you trying to CREATE FUNCTION? or
something else?
What steps have you tried so far and what errors have you got?
Is the .so file readable by the same user that is running PostgreSQL?
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://
g any schema changes until you are happy to stay with
8.x will help and you could just dump data only to go back.
--
Shane Ambler
[EMAIL PROTECTED]
Get Sheeky @ http://Sheeky.Biz
---(end of broadcast)---
TIP 6: explain analyze is your friend
46 matches
Mail list logo