Karthikeyan Sundaram wrote on 18.02.2007 09:15:
Hi,
I am new to postgres. I need some kind of template script or advise
on how to analyse the indexes. In our database, we do delete, insert,
update tons of rows.
http://www.postgresql.org/docs/8.2/interactive/routine-reindex.html
Andreas Wenk wrote on 16.07.2009 11:14:
dayat schrieb:
Hi pgsql admins,
I think the postgresql 8.4.0 binaries-no-installer for win32 exists in
http://www.postgresql.org/ftp/binary/v8.4.0/win32/ . Who are know
where I can to get this file.
EnterpriseDB also provides a ZIP archive of the
Emanuel Calvo Franco, 02.11.2009 21:27:
I have a trouble in creating user and database in postgres. whenever I
create user or databases in capital letters, the names are always
converted into names in lower case letter. what's wrong with it?
Thanks
Dong
Try add
CREATE USER PepeArgento;
Venkateswara Rao Bondada, 11.12.2009 10:58:
I’m trying to look at the source code of a function in PostgreSQL. Could
anybody please let me know how to view the same?
select pg_catalog.pg_get_functiondef(oid)
from pg_proc
http://www.postgresql.org/docs/current/static/functions-info.html
As
seetharaman jayaraman wrote on 15.03.2010 10:13:
how to get notification in front end application when ever postgre DB
table is modified, any tool, jar, api available?
thanks regards
seetharaman. j
Have a look at listen/nofify
http://www.postgresql.org/docs/current/static/sql-listen.html
Hi,
I'm trying to understand the information shown in pg_stat_bgwriter.
If I want to identify a possible bottleneck with the bgwriter, for what kind of
numbers do I need to watch out?
Are the following values OK, or do they indicate that I need to tune my
configuration?
checkpoints_timed :
Greg Smith wrote on 08.06.2010 19:30:
Thomas Kellerer wrote:
If I want to identify a possible bottleneck with the bgwriter, for
what kind of numbers do I need to watch out?
You don't much with a single snapshot of pg_stat_bgwriter data. Try
saving this instead:
select *,now() from
Greg Smith, 09.06.2010 07:14:
I probably should have explained the next part. I've now shared what I
do with this information at
http://www.pgcon.org/2010/schedule/events/218.en.html
Basically, if you put the data from the two snapshots into one of the
Statistics Spreadsheet versions, you'll
Walter Willmertinger, 05.07.2010 11:46:
*Advanced users* can also download a zip
archivehttp://www.enterprisedb.com/products/pgbindownload.do of
the binaries, without the installer.
That page *does* contain the zip files
It says Binaries from installer version 8.4.4-1 right above the download
Hi,
we are contemplating the possibilities for a Postgres HA installation.
As the rollout is targeted towards the end of the year, 9.0 and it's new
features might be an option for us.
Now from a HA point of view, what is the major difference between 9.0's Hot
Standby and 8.x's Warm Standby?
Hi,
Rob Wultsch wrote on 09.07.2010 18:14:
I am aware that I can use the 9.0 standby server for read only queries, but
that is (currently) not something we need
Taking SQL backups without impacting the master might be something to consider.
Interesting point. Thanks for mentioning that.
Greg Smith, 10.07.2010 14:44:
Is there a difference in how much data could potentially be lost in
case of a failover? E.g. because 9.0 replicates the changes quicker than 8.4?
There's nothing that 9.0 does that you can' t do with 8.4 and the right
software to aggressively ship partial files
Greg Smith, 12.07.2010 18:11:
Yes, but if you try you'll discover that actually getting any shared
disk or file system replication solution setup so that you really do
achieve less failover loss than the file shipping approach will be
expensive, complicated, fragile in its own way, and just
Hi,
I'm trying to setup a warm standby server. But there are some things that I
don't yet understand.
I'm testing this on my windows box to understand the concepts and while waiting
for the real hardware ;)
I got the basic setup working, and a simulated failover was working, but some
things
Hello,
I could solve one of the questions myself :)
I have also problems shutting down the secondary server while it is in
standby (i.e. recovery) mode
This works fine when using -m fast instead of -m immediate.
I would still like an answer on these questions:
What is the recommended way
Kasia Tuszynska wrote on 18.09.2010 01:30:
1. The doc is lovely but all of the examples are for linux, has
anyone tired a Hot Standby streaming scenario on windows? Any issues
specific to windows? I know that linux and windows environments
“should” behave the same but actually running in both of
Joe Carr wrote on 18.10.2010 23:11:
Hello all, I have a windows postgres 9.0.1 installation which doesn't
start, and also doesn't log any information. The only evidence that
an attempt was made is in the event log with the following pair of
messages :
1. Waiting for server startup... 2. Timed
Lukasz Brodziak, 25.10.2010 15:49:
Hello,
What I need to do is create a batch file to be sent to client in which
I have to perform create role statement. Best thing would be if the
user didn't see what is happening in the console (is there a @echo off
equivalent for psql). Can anyone help me
Lukasz Brodziak, 26.10.2010 08:58:
The problem with a batch file is that you will need to provide the password
for the superuser in clear text - which is probably not something you will
want to do.
But if that isn't a problem (and you actually know the superuser password of
your client) then
Lou Picciano, 12.11.2010 15:40:
Friends,
This question from our users keeps coming up...
What tools are each of you using for ERD ERM? pgAmin's Graphical Query Builder
is helpful, but doesn't address the need.
Can any of you recommend specific tools, preferences, etc?
Regards, Lou Picciano
Joe Carr wrote on 19.10.2010 00:55:
Hi Thomas, Thanks for your reply. pg_ctrl has given me some more
information, but I'm not quite there yet.
I have verified that the postgres user has full control access to
the data directory.
When I take the commandline from the service definition and
Gnanakumar, 03.02.2011 13:00:
Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
to multirow VALUES syntax available for INSERT?
INSERT Multirow VALUES syntax example:
INSERT INTO films (code, title, did, date_prod, kind) VALUES
('B6717', 'Tampopo', 110,
Sairam Krishnamurthy, 15.02.2011 23:43:
Again,
pg_ctl: could not open PID file
/media/extension/var/lib/postgresql/8.4/main/postmaster.pid: Permission denied
Tried all the different ownership possible.
And you are sure you ran that as the postgres user?
Thomas
--
Sent via pgsql-admin
Lukasz Brodziak, 14.03.2011 10:26:
Hello,
Is there a way of disabling/dropping all constrainsts in a given
database? I need to restore a db which has duplicate values in nearly
half of its tables then remove duplicates and then add the constraints
back. Is there a way to do that for each table
Saurabh Agrawal, 20.04.2011 08:38:
Hi All,
I am trying to alter column from timestamp without timezone to
bigint but getting below error:
#ALTER TABLE test ALTER column time type bigint;
#ERROR: column time cannot be cast to type bigint
Is there any other method for alter column to bigint.
jtke...@verizon.net wrote on 02.05.2011 18:52:
I've just started working on an 8.4 database and I have been asked to
extract all the functions source code stored in various databases and
schemas so they can be put into a repository for the developers. I'm
planning to use
Didik Prasetyo wrote on 07.05.2011 09:28:
I want to ask how to make GRANT, where users can only perform SELECT
on all the TABLE, in the database, which I have done the following
You might consider upgrading, because since 9.x you can do:
GRANT SELECT ON ALL TABLES IN SCHEMA public;
Thomas
jtke...@verizon.net, 05.07.2011 18:44:
A while ago the some developers inserted several records with a
document (stored in doc_Data) that was around 400 - 450 MB each. Now
when you do a select * (all) from this table you get a hang and the
system becomes unresponsive.
What application/program
Rural Hunter, 27.09.2011 11:00:
I am looking for something like a string hash function to order a string cloumn
randomly.
It's all in the manual ;)
http://www.postgresql.org/docs/current/static/functions-string.html
Thomas
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
Gnanakumar, 31.01.2012 09:11:
Hi,
Our Production server is running PostgreSQL v8.2.22 on CentOS5.2.
You know that 8.2 is end-of-live?
http://www.postgresql.org/support/versioning/
There are 2 columns in the table: managertype numeric(1) and managerid
numeric(10). managertype accepts only
Scott Marlowe, 05.02.2012 23:13:
Not sure what you mean by community edition. There's PostgreSQL.
From the postgresql.org website, which is what most folks use.
I think the term community edition was coined by EnterpriseDB - at least it
shows up on their webpages on some places.
--
Sent
ЇЯЅHAÐ wrote on 17.04.2012 01:27:
Hi,
We are trying to migrate from Postgres to Oracle, although our DB is gigantic
but we started on Mar 14th 2012 its still running with an average of 40
records per day
How can we check what is going wrong.
Any memory leak, CPU issue or anything.
If
Wells Oliver, 22.04.2012 00:58:
Is there a way to get the date that starts week 14, or 15 (etc)?
Try this:
select to_date('201214', 'iyyyiw')
That uses the ISO week definition.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
Bèrto ëd Sèra wrote on 01.05.2012 11:13:
Hi all,
I'm asked to benchmark a PG-related product. I was wondering if there
is any sort of standard public dataset for such operations. The one
and only limit I have is I cannot use triggers with this product
(otherwise I'd use a copy of our own
Hi,
I'm trying to enable ident authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
I get an error message when trying to login (after a server reload
Magnus Hagander, 04.05.2012 15:22:
I'm trying to enable ident authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
sameuser was removed in PostgreSQL
Madhu.Lanka, 19.07.2012 11:14:
Hi Friends
Can u please help to write a function for the following scenario?
I have 3 table’s user_roles, principals and roles.
I have to write a function in postgresql which should excepts 2 parameters
(name, password)
With those 2 parameters the query should
using Windows XP SP3 (32bit).
When running pg_upgrade with the --check option I get the following error:
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using
Thomas Kellerer wrote on 12.09.2012 11:09:
Is there a way to find out which function (or extension?) is using those
libraries in order to remove that dependency?
What I ended up doing is to search through my pg_dump backups and I found the
offending database.
After removing the functions
Campbell, Lance wrote on 14.02.2013 20:09:
PostgreSQL 9.2
When creating a table or altering a column of a table, is there a way
to add notes on a column?
comment on table foo is 'the foo table';
comment on column foo.bar is 'the bar column';
Szymon Guz, 06.05.2013 20:25:
That's strange. I've never met any newsgroup which would require top
posting. Top posting has always been considered rude.
We are reading from top to bottom. That's why people should answer
below cited text, so we can read it later normally. I mean that I
should
Technical Doubts wrote on 20.06.2013 09:42:
technologies
(
technologyid bigint,
status character(1),
implementeddate date
*CONSTRAINT technologies_uq UNIQUE (technologyid, status, implementeddate)*
)
entering data as
insert into technologies (technologyid,status,implementeddate)
values
Manish Kediyal wrote on 29.07.2013 09:17:
I have various DB in my DB cluster, i want to vacuum all DB's using a shell
script.. scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum
all DB's
Is there a specific reason you don't want to use
43 matches
Mail list logo